Results 1 to 2 of 2

Thread: Store and Execute Sql in MS Access Table

Threaded View

  1. Apr 7th, 2006, 10:15 PM #1
    dearpretender
    dearpretender is offline

    Thread Starter
    New Member
    Join Date
    Apr 2006
    Posts
    1

    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?
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width