SQL error with visual foxpro

This public forum is for user-to-user discussions of ASPMaker. Note that this is not support forum.

SQL error with visual foxpro

Postby neosystems » Fri Oct 20, 2017 1:09 pm

We are using OLEDB to connect using connection strog to visual foxpro .DBC

We can see all the tables and generate asp files without problem, but weh we tried to join 2 tables to create a Custom View, on ASP GUI Custom View run ok, but running alive when we try to short the information we reveive the bellow error:

Load recordset error. SQL: 'SELECT existe.cve_prod, producto.desc_prod FROM existe INNER JOIN producto ON existe.cve_prod = producto.cve_prod ORDER BY existe.[cve_prod] ASC'. Description: Syntax error.

Seems like the problem is the file named for ASP maker: existe.[cve_prod] it should be just> existe.cve_prod

I need to chage the expression field name: existe.[cve_prod] to existe.cve_prod...without: [ ]

Where is the place to change it:

Thank you!
Noah
neosystems
 
Posts: 1
Joined: Fri Aug 15, 2014 11:34 pm

Re: SQL error with visual foxpro

Postby Webmaster » Fri Oct 20, 2017 3:53 pm

Always avoid Custom View if possible. Create the view directly in your database instead.

If you really need to create the Custom View, use the SQL panel (instead of the Builder panel) to enter your SQL directly.
Webmaster
 
Posts: 10731
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (ASPMaker)