Recent

Author Topic: SqlitePass without DataAware component  (Read 4938 times)

mrdebug

  • Full Member
  • ***
  • Posts: 160
SqlitePass without DataAware component
« on: October 16, 2007, 02:16:06 pm »
Have you got an example of SqlitePass database without DataAware Component?

Luc

  • Jr. Member
  • **
  • Posts: 59
RE: SqlitePass without DataAware component
« Reply #1 on: October 20, 2007, 11:35:11 pm »
- Drop a SqlitePassDatabase and a SqlitePassDataset on your form (named SqlitePassDatabase1 and SqlitePassDataset1).
 - Connect SqlitePassDatabase1 to a db (tested with a kexi db in  /demo/database). Connected := True
 - Connect SqlitePassDataset1 to SqlitePassDatabase1.
 - Select a table, query or enter your select sql statement
 - Set SqlitePassDataset1.Active := True;
 - Drop, for example, a memo + a button on your form and assign the button.onclick event.
   
   procedure TForm1.Button1Click(Sender: TObject);
   begin
   SqlitePassDataset1.Next;
   Memo1.Lines.Add(SqlitePassDataset1.Fields.FieldByName('Name').AsString);
   end;

This will display the value of the field 'Name' every time you click the button.

This is just a quick/dirty example. Let me know if you need to achieve a specific task.

Regards.

Luc.
Win 11 ARM (Running in Parallel VM - Mac OSX) - Lazarus 2.2.6 - i386-win32/win64

 

TinyPortal © 2005-2018