SQL doubt

[bigdad]

hi every body I need of yours knowledge my pal...


I´ve a Sql sentence and I can´t order it my question is how Can I order it??? I try with "Order by" in all position of its (the beginnig, at the end, at middle)but this no work.

my sentence is:
=sqlprepare(conex,"SELECT Tbregion.region, Tbcentro.centro, Tbmov.estatus, Tbmov.fecha, Tbmov.nactivo,Tbmov.codmov FROM serflot!tbregion INNER JOIN serflot!tbcentro INNER JOIN serflot!tbmov ON Tbcentro.codcentro = Tbmov.codcentro ON Tbregion.codregion = Tbcentro.codregion","movimiento&quot

=sqlexec(conex)

I hope someone can help me

bigdad

 

[rgbean]

When using SPT (SQL passthough), the syntax is ultimately dependent on the server type itself (e.g. Oracle, MySQL, DB2, MS SQL, Access, etc.). That is, it's not a VFP "problem". What are you connecting to?

Rick

 

[fluteplr]

also after you run the sqlexec check the message() function you may get a more helpful error message.