2 Attachment(s)
Store and Execute Sql in MS Access Table
Please refer to attached Sql2.txt and MyCoding1.txt before reading below.
My problem is that it will be quite slow when there is a lots of record as i have to loop through all records of tblC and then insert it into flexgrid.
What i have in mind is only 1 Sql command to display the output:
MyRst1.Open MySQL1
Set FlexGrid1.DataSource = MyRst1
FlexGrid1.Refresh
izzit possible?
Re: Store and Execute Sql in MS Access Table
you might want to search the forum for "stored procedures" which has been discussed many times.
