TIA
I`m working on an special agenda with daily appointments. I take some data from the table agenda some from the clients in order to create a temporay table tmpAgenda
This is the code what I`m using
- Code: Select all
dbpOpenTable "Fdent" "Agenda" ""
...///
dbpExecSQL "fdent" "SELECT Agenda.nTime, Agenda.Subject, Agenda.NextDate, HCO.LastName, HCO.Name, HCO.Phone, HCO.CelPhone INTO tmpAgenda|FROM HCO INNER JOIN Agenda ON HCO.IdClient = Agenda.Client|WHERE (((Agenda.Nextdate)=#[nDate]#))|ORDER BY Agenda.nTime;|" ""
dbpOpenTable "Fdent" "tmpAgenda" ""
When I test it on MS Access it works fine. I change [nDate] adding or substracting a day but when i made the sql consult again doesn't work. The tmpAgenda is empty. The question is, how you can I enforce the creation of a temporary table?
I will appreciate any help.
carlost