Re: [Lazarus] SQLite: How to create lookup fields? [Implemented in fpc trunk]

2009-02-21 Thread Luiz Americo Pereira Camara
Luiz Americo Pereira Camara escreveu: User escreveu: Hi again, my TSQLite3Dataset components: DatasetSales with the fields: Code, Item, Amount, Price, Vendor DatasetItems with the fields: Code, Description I do not want that the lookup field to be editable. My new code: procedure

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-27 Thread Joost van der Sluis
Op donderdag 25-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: 4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while scrolling DBGrid.at are very hard t find Dont spend too much time in this

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-27 Thread z0m...@gmx.net
Op donderdag 25-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: 4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while scrolling DBGrid.at are very hard t find Dont spend too much time in this

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-27 Thread Joost van der Sluis
Op zaterdag 27-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: Op donderdag 25-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: 4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-27 Thread z0m...@gmx.net
Op zaterdag 27-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: Op donderdag 25-12-2008 om 14:06 uur [tijdzone +0100], schreef z0m...@gmx.net: 4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-26 Thread Luiz Americo Pereira Camara
User escreveu: Hi again, my TSQLite3Dataset components: DatasetSales with the fields: Code, Item, Amount, Price, Vendor DatasetItems with the fields: Code, Description I do not want that the lookup field to be editable. My new code: procedure TForm1.FormCreate(Sender: TObject); var

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-26 Thread Alexander Klenin
On Fri, Dec 26, 2008 at 11:28, User usuarioanonimomy...@gmail.com wrote: Hi again, my TSQLite3Dataset components: My new code: [skip] but nothing happen. Why? Because, as I already pointed out: On Thu, Dec 25, 2008 at 21:05, Alexander Klenin kle...@gmail.com wrote: It seems to be

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-25 Thread Alexander Klenin
I do it: procedure TForm1.FormCreate(Sender: TObject); begin with DatasetSales do begin Open; DatasetItems.Open; FieldByName('Item').FieldKind := fkLookup; FieldByName('Item').LookupDataSet := DatasetItems; FieldByName('Item').LookupKeyFields := 'Code; Description';

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-25 Thread z0m...@gmx.net
4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while scrolling DBGrid.at are very hard t find Dont spend too much time in this SQLite3DataSet has a lot of Bugs. ill tryed to fix all for month before i used zeos On

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-25 Thread z0m...@gmx.net
4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while scrolling DBGrid.at are very hard t find Dont spend too much time in this SQLite3DataSet has a lot of Bugs. ill tryed to fix all for month before i used zeos On

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-25 Thread User
Hi again, my TSQLite3Dataset components: DatasetSales with the fields: Code, Item, Amount, Price, Vendor DatasetItems with the fields: Code, Description I do not want that the lookup field to be editable. My new code: procedure TForm1.FormCreate(Sender: TObject); var TempField: TStringField;

Re: [Lazarus] SQLite: How to create lookup fields?

2008-12-25 Thread Luiz Americo Pereira Camara
z0m...@gmx.net escreveu: 4) Even after this, there is some problems in SQLdb which I did not yet found time to diagnose and fix properly. They cause AVs while scrolling DBGrid.at are very hard t find Dont spend too much time in this SQLite3DataSet has a lot of Bugs. ill tryed to fix

[Lazarus] SQLite: How to create lookup fields?

2008-12-24 Thread User
Hi, I have two TSQLite3Dataset components: DatasetSales with the fields: Code, Item, Amount, Price, Vendor DatasetItems with the fields: Code, Description I have a TDBGrid component that shows the data of DatasetSales. I want to make a lookup field associated to the Item DatasetSales field to