Source language: Translate to:

Mostrar solo campos llenos y sin repeticion

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Re: Mostrar solo campos llenos y sin repeticion

Postby neobookruletin » Wed Dec 24, 2014 12:42 pm

dbpExecSQL "datos" "SELECT DISTINCT PROVEEDOR FROM Tabla1 WHERE (PROVEEDOR IS LIKE "[value]%");" ""



Image
neobookruletin
 
Posts: 31
Joined: Tue Nov 25, 2014 9:17 am

Re: Mostrar solo campos llenos y sin repeticion

Postby neobookruletin » Wed Dec 24, 2014 12:46 pm

Gaev, thanks for helping me be, and Merry Christmas
neobookruletin
 
Posts: 31
Joined: Tue Nov 25, 2014 9:17 am

Re: Mostrar solo campos llenos y sin repeticion

Postby Gaev » Wed Dec 24, 2014 3:48 pm

neobookruletin:

You CAN NOT use double quotes ( " ) inside of other double quotes ... so you have to surround [value]% with single quotes ( ' ) ... so try ...

dbpExecSQL "datos" "SELECT DISTINCT PROVEEDOR FROM Tabla1 WHERE (PROVEEDOR IS LIKE '[value]%');" ""
User avatar
Gaev
 
Posts: 3716
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Previous

Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests