[Lazarus] SQLDB issues.

[Matt Shaffer]

Different issue: Saving to the database. I can't manage to figure this one
out.
If I do: query.ApplyUpdates; the database isn't actually written to.
If I do: query.Post; query.ApplyUpdates; it says that it's not set for
editing.

So, where I'm having trouble is where to set the state? I've
done query.State := dsEdit; but that understandably yells at me..
On Tue, Jan 5, 2010 at 3:49 PM, Matt Shaffer <dazappa.matt at gmail.com> wrote:

> It turned out that for some reason restarting the IDE fixed the problem.
> The data now populates happily.
>
> 2010/1/5 Michael Van Canneyt <michael at freepascal.org>
>
>
>> Can you post the files somewhere ? It should work; it sure does here.
>>
>> BTW. You can set the 'Active' property to true even in the designer,
>> it should show the data in the grid as well.
>>
>> Michael.
>>
>>
>> On Tue, 5 Jan 2010, Matt Shaffer wrote:
>>
>>  Yes, it is indeed.
>>>
>>> On Tue, Jan 5, 2010 at 1:21 AM, Serge Girard (via Orange) <
>>> girard.sergea at orange.fr> wrote:
>>>
>>>  Matt Shaffer a écrit :
>>>>
>>>>  So I found this helpful wiki page
>>>>
>>>>> http://wiki.lazarus.freepascal.org/SQLdb_Package for getting started
>>>>> with
>>>>> the db components. Great! I (believe) I've followed the tutorial
>>>>> exactly,
>>>>> everything's working until I try to drop a tdbgrid with my datasource
>>>>> onto
>>>>> the form. No data is shown. I double check my sql query, "select * from
>>>>> actions", I click the run button and the data shows, so I was confused
>>>>> as to
>>>>> why it wouldn't show in the grid. I compiled the program anyway,
>>>>> thinking
>>>>> maybe the IDE's auto query executor was broken, but no luck. Still
>>>>> completely blank. I've tried the same thing with a dblistbox as well.
>>>>>
>>>>>  Uhm , is your DbGrid/dblistbox linked to a datasource , and the
>>>> datasource
>>>> to your Query ?
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> _______________________________________________
>>>> Lazarus mailing list
>>>> Lazarus at lists.lazarus.freepascal.org
>>>> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>>>>
>>>>
>> --
>> _______________________________________________
>> Lazarus mailing list
>> Lazarus at lists.lazarus.freepascal.org
>> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20100105/a780c374/attachment-0004.html>