Hello,
I have a problem with DataSet.
I wrote a program in c++ Builder 6 and it uses MySQL database. Obviuosly I was using VCL.
I wanted to put into DataSet->CommandText something like: "source c:\path\file.sql" (certainly without "") but there is one problem.
Because of the colon everything after the colon is a parameter. For example, phrase: select * from table where idrecord = :idrecord. Here colon in :idrecord means that idrecord is parameter. So when I put there: source c:\path\file.sql then \path\file.sql is a parameter. What can I do to prevent this? I really need to use source command in DataSet.
Thanks a lot and sorry for my bad English