New company guidelines demand we convert all Paradox data to Access or MSSQL, so we have started to look at the Delphi Apps (Delphi 7) and changing from BDE to ADO. However need a bit of guidance.
Most data forms use the same format - Data loaded to DBGrid, either click on an Add button, or highlight the wanted record, and click on Edit or Delete buttons. Data then transferred to variables to be edited in TEdits saved.
No problem with data where data is from a single ADOTable , but need guidance where ADOQuery is used on data from joined tables (e.g. SELECT a.col2, a.col3, b.col2 FROM table1 a, table2 WHERE b.col1 = a.col1). In this case we can get the data into variables for table1, but not table2 (b.col2 from above example).
Most examples I have seen don't relate to such a situation - can anyone point to any online ones that will help (company not willing to pay for training on "legacy" systems!)
Many thanks
Most data forms use the same format - Data loaded to DBGrid, either click on an Add button, or highlight the wanted record, and click on Edit or Delete buttons. Data then transferred to variables to be edited in TEdits saved.
No problem with data where data is from a single ADOTable , but need guidance where ADOQuery is used on data from joined tables (e.g. SELECT a.col2, a.col3, b.col2 FROM table1 a, table2 WHERE b.col1 = a.col1). In this case we can get the data into variables for table1, but not table2 (b.col2 from above example).
Most examples I have seen don't relate to such a situation - can anyone point to any online ones that will help (company not willing to pay for training on "legacy" systems!)
Many thanks
