dbTalk Databases Forums  

UNIDATA ERRO IN CreateUniCommand

comp.databases.pick comp.databases.pick


Discuss UNIDATA ERRO IN CreateUniCommand in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alegon
 
Posts: n/a

Default UNIDATA ERRO IN CreateUniCommand - 09-11-2006 , 03:04 PM






HI,

IT DOES NOT FUNCTION THE COMMAND IN VB .NET

cmd = US.CreateUniCommand()
Comando = "SORT BP = "TEST]"
cmd.Command = Comando
cmd.Execute()

IN UTCL THE COMMAND THIS OK

COMMANDS THAT DO NOT POSSESS SELECTION ARE OK.

SAMPLE OK IN VB .NET

cmd = US.CreateUniCommand()
Comando = "SORT BP"
cmd.Command = Comando
cmd.Execute()


Reply With Quote
  #2  
Old   
Symeon
 
Posts: n/a

Default Re: UNIDATA ERRO IN CreateUniCommand - 09-11-2006 , 03:19 PM






alegon wrote:
Quote:
HI,

IT DOES NOT FUNCTION THE COMMAND IN VB .NET

cmd = US.CreateUniCommand()
Comando = "SORT BP = "TEST]"
hi alegon, in .net if you want a string to contain quotes you use
double quotes, so the above would be
Comando = "SORT BP = ""TEST]"""

rgds
Symeon



Reply With Quote
  #3  
Old   
alegon
 
Posts: n/a

Default Re: UNIDATA ERRO IN CreateUniCommand - 09-12-2006 , 06:39 AM




Symeon escreveu:

Quote:
alegon wrote:
HI,

IT DOES NOT FUNCTION THE COMMAND IN VB .NET

cmd = US.CreateUniCommand()
Comando = "SORT BP = "TEST]"

hi alegon, in .net if you want a string to contain quotes you use
double quotes, so the above would be
Comando = "SORT BP = ""TEST]"""

rgds
Symeon
Hi Symeon,

thus also it does not find itens :

Comando = "SORT BP = ""TEST]""" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = 'TEST]'" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = \TEST]\" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = /TEST]/" (return cmd.SystemReturnCode = -1)



Reply With Quote
  #4  
Old   
alegon (Offline)
Junior Member
 
Posts: 5
Join Date: Aug 2006

Default Also it does not find itens - 09-12-2006 , 06:46 AM



Hi Symeon,

thus also it does not find itens :


Comando = "SORT BP = ""TEST]""" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = 'TEST]'" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = \TEST]\" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = /TEST]/" (return cmd.SystemReturnCode = -1)

Reply With Quote
  #5  
Old   
frosty
 
Posts: n/a

Default Re: UNIDATA ERRO IN CreateUniCommand - 09-12-2006 , 04:51 PM



Perhaps this:
Comando = "SORT BP = " & CHR$(34) & "TEST" & CHR$(34)
or similar.

¡Buenas suerte!

--
frosty

alegon wrote:
Quote:
Symeon escreveu:

alegon wrote:
HI,

IT DOES NOT FUNCTION THE COMMAND IN VB .NET

cmd = US.CreateUniCommand()
Comando = "SORT BP = "TEST]"

hi alegon, in .net if you want a string to contain quotes you use
double quotes, so the above would be
Comando = "SORT BP = ""TEST]"""

rgds
Symeon

Hi Symeon,

thus also it does not find itens :

Comando = "SORT BP = ""TEST]""" (return cmd.SystemReturnCode = -1)
Comando = "SORT BP = 'TEST]'" (return cmd.SystemReturnCode =
-1) Comando = "SORT BP = \TEST]\" (return cmd.SystemReturnCode
= -1) Comando = "SORT BP = /TEST]/" (return
cmd.SystemReturnCode = -1)



Reply With Quote
  #6  
Old   
Symeon
 
Posts: n/a

Default Re: UNIDATA ERRO IN CreateUniCommand - 09-13-2006 , 04:07 AM



Hi Alegon

What ECLTYPE are you using?

ECLTYPE P will work with this syntax
ECLTYPE U will need
SORT BP WITH @ID LIKE "TEST..."

You can change your ECL type in the login paragraph for your account.


Rgds
Symeon.


Reply With Quote
  #7  
Old   
alegon
 
Posts: n/a

Default Re: UNIDATA ERRO IN CreateUniCommand - 09-13-2006 , 06:43 AM




Symeon escreveu:

Quote:
Hi Alegon

What ECLTYPE are you using?

ECLTYPE P will work with this syntax
ECLTYPE U will need
SORT BP WITH @ID LIKE "TEST..."

You can change your ECL type in the login paragraph for your account.


Rgds
Symeon.
Hi Symeon,

I use o ECLTYPE 'P'

ED MD LOGIN
Top of "LOGIN" in "MD", 5 lines, 58 characters.
001: PA
002: ECLTYPE 'P'
003: BASICTYPE 'P'
004: UDT.OPTIONS 11 ON
005: DATE-FORMAT

or in vb. net I have that to define some property ?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.