Search results

select mb-num from pro1.mb where logindate='30-NOV-08' will be like select mb-num from pro1.mb where logindate={ d 1980/5/19 }

I'm using progress 91D and the odbc driver from OpenLink 3.2. I want to make the following sql statement select mb-num from pro1.mb where logindate='30-NOV-08' but it gives me an error What is the correct way to make this statement Thanks

Hi, I'm using crystal reports 9 to connect to Progress using odbc specifically the driver from OpenLink 3.20 Well, I'm able to see the all the tables from progress in crystal reports, even select columns I want to use, but when I try to see the preview I received the following error Failed to...

Thanks, For my DB it was select _file-name from pro1._file where _file._hidden = 0 I'm surprise by the fast help all of you provide me

Thanks, one question I think that the following sql statement SELECT * FROM pub.\"_field\" WHERE \"_file-recid\" = (SELECT ROWID FROM pub.\"_file\" WHERE \"_file-name\" = YourTableName) Dose this statement returns all the fields "columns" from a table? I think so because the parameter...

Hi, Thanks for your help. I'm developing like an "MSSQL Enterprise Manager" for Progress in .net. By the way if some one knows one for free please let me know. I'm starting by the basics, a sql statement to return all tables in a database, can some one help me...