Recent

Author Topic: query method list  (Read 2948 times)

klyxmaster

  • New Member
  • *
  • Posts: 25
query method list
« on: September 02, 2014, 08:08:32 pm »
This is pretty general LOL
I used to work with pascal back in the BBS days (as most doors were written in pascal variant).
with that said, I was happy to see when pascal was alive again, AND can interface with mysql!! woot!!
so my question:
is there a list somewhere for the query methods? I may be asking it incorrectly, if so I apologize to the pro's.
example
query.next
query.first
...eof
recordcount etc..
recordcount got me stumped because I did not know it existed, so had to get creative with my sql string  8-) until i found it posted in another not related example.

I checked all the wiki's but all they do is just give various example.

and if you need more info.
I am making a select function and returning the results in an array. however

 [pseudo code]
loop until sql.eof
 thisArray
  • := a record found

end loop

writeln (thisArray[36]['name']):


but I really hate to come back to the forums, if I can just find the methods.

thanks for keeping a great language alive

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: query method list
« Reply #1 on: September 02, 2014, 09:47:41 pm »
Are you serious?

It took me 30 seconds to find this page
Also this TDataset page tells all the properties and methods (this delphi site but tells exactly the same)
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

klyxmaster

  • New Member
  • *
  • Posts: 25
Re: query method list
« Reply #2 on: September 03, 2014, 12:21:18 am »
puuleeez!
 took me 1 second to find those pages.. that was last week.
besides that 2nd page never came up in my searches

only pages linked to here were of any interest to me
http://wiki.freepascal.org/mysql#SQLDB

I'll check out that second link - looks promising.
what search criteria did you use to arrive at that page? Using "pascal sql" only yeilds the wiki pages

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: query method list
« Reply #3 on: September 03, 2014, 08:19:06 am »
TDataset Delphi :D
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: query method list
« Reply #4 on: September 03, 2014, 08:36:17 am »
Try
Tdataset lazarus

First hit:  :)
http://www.freepascal.org/docs-html/fcl/db/tdataset.html

O, yeah... and the second hit has lots of info and links too:
http://wiki.freepascal.org/Databases
« Last Edit: September 03, 2014, 08:40:59 am by rvk »

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: query method list
« Reply #5 on: September 03, 2014, 03:54:08 pm »
Even better :D
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

 

TinyPortal © 2005-2018