SELECT t1.codigocliente AS t1_codigocliente, t1.nombre AS t1_nombre, t1.apellidos AS t1_apellidos, t1.nif AS t1_nif, t1.razonsocial AS t1_razonsocial, t1.fechaalta AS t1_fechaalta, t1.CodigoFormaPago AS t1_CodigoFormaPago, t1.codigoformaenvio AS t1_codigoformaenvio, t1.CreatedDate AS t1_CreatedDate, t1.ModifiedDate AS t1_ModifiedDate, t2.CodigoFormaPago AS t2_CodigoFormaPago, t2.nombre AS t2_nombre, t2.CreatedDate AS t2_CreatedDate, t2.ModifiedDate AS t2_ModifiedDate, t3.codigoformaenvio AS t3_codigoformaenvio, t3.nombre AS t3_nombre, t3.CreatedDate AS t3_CreatedDate, t3.ModifiedDate AS t3_ModifiedDate FROM ((cliente as t1 LEFT JOIN FormaPago as t2 ON t1.CodigoFormaPago = t2.CodigoFormaPago) LEFT JOIN formaenvio as t3 ON t1.codigoformaenvio = t3.codigoformaenvio) WHERE t1.codigocliente = 12
but this instruction is bad:
the correct is:
SELECT t1.codigocliente AS t1_codigocliente, t1.nombre AS t1_nombre, t1.apellidos AS t1_apellidos, t1.nif AS t1_nif, t1.razonsocial AS t1_razonsocial, t1.fechaalta AS t1_fechaalta, t1.CodigoFormaPago AS t1_CodigoFormaPago, t1.codigoformaenvio AS t1_codigoformaenvio, t1.CreatedDate AS t1_CreatedDate, t1.ModifiedDate AS t1_ModifiedDate, t2.CodigoFormaPago AS t2_CodigoFormaPago, t2.nombre AS t2_nombre, t2.CreatedDate AS t2_CreatedDate, t2.ModifiedDate AS t2_ModifiedDate, t3.codigoformaenvio AS t3_codigoformaenvio, t3.nombre AS t3_nombre, t3.CreatedDate AS t3_CreatedDate, t3.ModifiedDate AS t3_ModifiedDate FROM cliente as t1 LEFT JOIN FormaPago as t2 ON t1.CodigoFormaPago = t2.CodigoFormaPago LEFT JOIN formaenvio as t3 ON t1.codigoformaenvio = t3.codigoformaenvio WHERE t1.codigocliente = 12
the diferent is the brackets, maxdb don't support
Saludos
Victor (Madrid-Spain)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am used this in xml
<database name="erp" class="CODBCDatabase">
I suppose that now I must change the following code
<database name="erp" class="CMaxDBDatabase">
but The following mistake is produced:
Excepcin no controlada del tipo 'System.ArgumentException' en mscorlib.dll
Informacin adicional: Ya se ha agregado el elemento. Clave en el diccionario: "server" Clave agregada: "server"
Saludos
Victor(madrid - spain)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am used this in xml
<database name="erp" class="CODBCDatabase">
I suppose that now I must change the following code
<database name="erp" class="CMaxDBDatabase">
but The following mistake is produced:
Excepcin no controlada del tipo 'System.ArgumentException' en mscorlib.dll
Informacin adicional: Ya se ha agregado el elemento. Clave en el diccionario: "server" Clave agregada: "server"
I think that the connection mysql is diferent that the MaxDB
Saludos
Victor(madrid - spain)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ah, I thought that since MaxDB is based on MySQL that you were trying to connect using the MySQL .NET provider. I can see that you are actually connecting using ODBC.
Since you have the code at the moment, can you change the MaxDB class to inherit from CODBCDatabase and see if that fixes the problem.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
your code generate is (with last CVS) :
SELECT t1.codigocliente AS t1_codigocliente, t1.nombre AS t1_nombre, t1.apellidos AS t1_apellidos, t1.nif AS t1_nif, t1.razonsocial AS t1_razonsocial, t1.fechaalta AS t1_fechaalta, t1.CodigoFormaPago AS t1_CodigoFormaPago, t1.codigoformaenvio AS t1_codigoformaenvio, t1.CreatedDate AS t1_CreatedDate, t1.ModifiedDate AS t1_ModifiedDate, t2.CodigoFormaPago AS t2_CodigoFormaPago, t2.nombre AS t2_nombre, t2.CreatedDate AS t2_CreatedDate, t2.ModifiedDate AS t2_ModifiedDate, t3.codigoformaenvio AS t3_codigoformaenvio, t3.nombre AS t3_nombre, t3.CreatedDate AS t3_CreatedDate, t3.ModifiedDate AS t3_ModifiedDate FROM ((cliente as t1 LEFT JOIN FormaPago as t2 ON t1.CodigoFormaPago = t2.CodigoFormaPago) LEFT JOIN formaenvio as t3 ON t1.codigoformaenvio = t3.codigoformaenvio) WHERE t1.codigocliente = 12
but this instruction is bad:
the correct is:
SELECT t1.codigocliente AS t1_codigocliente, t1.nombre AS t1_nombre, t1.apellidos AS t1_apellidos, t1.nif AS t1_nif, t1.razonsocial AS t1_razonsocial, t1.fechaalta AS t1_fechaalta, t1.CodigoFormaPago AS t1_CodigoFormaPago, t1.codigoformaenvio AS t1_codigoformaenvio, t1.CreatedDate AS t1_CreatedDate, t1.ModifiedDate AS t1_ModifiedDate, t2.CodigoFormaPago AS t2_CodigoFormaPago, t2.nombre AS t2_nombre, t2.CreatedDate AS t2_CreatedDate, t2.ModifiedDate AS t2_ModifiedDate, t3.codigoformaenvio AS t3_codigoformaenvio, t3.nombre AS t3_nombre, t3.CreatedDate AS t3_CreatedDate, t3.ModifiedDate AS t3_ModifiedDate FROM cliente as t1 LEFT JOIN FormaPago as t2 ON t1.CodigoFormaPago = t2.CodigoFormaPago LEFT JOIN formaenvio as t3 ON t1.codigoformaenvio = t3.codigoformaenvio WHERE t1.codigocliente = 12
the diferent is the brackets, maxdb don't support
Saludos
Victor (Madrid-Spain)
I am used this in xml
<database name="erp" class="CODBCDatabase">
I suppose that now I must change the following code
<database name="erp" class="CMaxDBDatabase">
but The following mistake is produced:
Excepcin no controlada del tipo 'System.ArgumentException' en mscorlib.dll
Informacin adicional: Ya se ha agregado el elemento. Clave en el diccionario: "server" Clave agregada: "server"
Saludos
Victor(madrid - spain)
I am used this in xml
<database name="erp" class="CODBCDatabase">
I suppose that now I must change the following code
<database name="erp" class="CMaxDBDatabase">
but The following mistake is produced:
Excepcin no controlada del tipo 'System.ArgumentException' en mscorlib.dll
Informacin adicional: Ya se ha agregado el elemento. Clave en el diccionario: "server" Clave agregada: "server"
I think that the connection mysql is diferent that the MaxDB
Saludos
Victor(madrid - spain)
Ah, I thought that since MaxDB is based on MySQL that you were trying to connect using the MySQL .NET provider. I can see that you are actually connecting using ODBC.
Since you have the code at the moment, can you change the MaxDB class to inherit from CODBCDatabase and see if that fixes the problem.
- Richard.
All right