Forum Discussion
Solved
ODBC connection - large table
Hello, I am trying to connect to a Jade database via an ODBC connection. I can see the tables (as per below) but when i select the individual table "JCJob" as per below, preview is evaluating doe...
alau020,
Glad to hear that issue is solved, you can accept helpful reply as answer, this way, other community members can easily found this solution when they get same issues.
Regards,
Lydia
How many columns and rows in this large table? Please select required columns and rows through SQL statement and then check if you can successfully load data.
Regards,
Lydia
Thank you Lydia.
The SQL code I have used worked.
alau020,
Glad to hear that issue is solved, you can accept helpful reply as answer, this way, other community members can easily found this solution when they get same issues.
Regards,
Lydia- Hello,
okay?
I need to insert two dates in SQL Statement with the following format '' DD-MM-YY '', 'DD-MM-YY' ", one being the current date (today) and the other 30 days ago.
how can I do this?
