[Lazarus] Generate a string with a record of SQLite3 database

2008-10-01 Thread Usuario Anónimo
Hello, I have a SQLite3 database and I want to send the records by lNet components. I need to create a string from the fields of the table. I have this: with DataModule1.Db do begin TableName := 'Item'; if not TableExists then begin FieldDefs.Clear;

Re: [Lazarus] Generate a string with a record of SQLite3 database

2008-10-01 Thread Joost van der Sluis
Op woensdag 01-10-2008 om 17:06 uur [tijdzone +0200], schreef Usuario Anónimo: sequence := Db.FieldValues['Code'] + '#' + Db.FieldValues['Proveedor'] + '#' + Db.FieldValues['Almacen'] + '#' + Db.FieldValues['Unidades']; Please don't use

Re: [Lazarus] Generate a string with a record of SQLite3 database

2008-10-01 Thread Joost van der Sluis
Op woensdag 01-10-2008 om 17:06 uur [tijdzone +0200], schreef Usuario Anónimo: sequence := Db.FieldValues['Code'] + '#' + Db.FieldValues['Proveedor'] + '#' + Db.FieldValues['Almacen'] + '#' + Db.FieldValues['Unidades']; btw: Where did

Re: [Lazarus] Generate a string with a record of SQLite3 database

2008-10-01 Thread Usuario Anónimo
I put Db. and the code completion show it. I am beginner. Regards. PD: Thank you very much, your solution is very good! 2008/10/1 Joost van der Sluis [EMAIL PROTECTED] Op woensdag 01-10-2008 om 17:06 uur [tijdzone +0200], schreef Usuario Anónimo: sequence := Db.FieldValues['Code'] + '#' +

Re: [Lazarus] Generate a string with a record of SQLite3 database

2008-10-01 Thread Inoussa OUEDRAOGO
btw: Where did you get the idea to use FieldValues from? I don't know anybody using it? Did you find it somewhere on the net, or did you found it out yourselve? (Using ideas from other program-languages?) FieldValues is an old property of TDataset, so it seems to me that it is a rather used