ADS Client Server (SAP)

[rdonnay]

What did you use as the value for cServer?

Did you use cServer := "\\ae-data01:6262\Apps\Omni\oiswin" ?

[omni]

Roger,

Ok, I just copied from the c-drive test and changed the drive letter..wasn't thinking.

This one finally worked.

TEXT INTO cSql WRAP
SELECT * INTO ownrtest FROM OWNER
ENDTEXT

cServer := '\\ae-data01:6262\Apps\Omni\oiswin'
cErrorString := ''

set default to z:\oiswin

DC_ExecuteSQL( cServer, cSql,,,,,,,,,@cErrorString )

IF !Empty(cErrorString)
DCMSGBOX cErrorString
RETURN .f.
ENDIF

RETURN nil

Final change was to set the default. Failed initially..could not find the file.


Thought I would copy it here in case somebody sometime has this type of set up.

I think most of that can be put in one function so all I have to do is that function with the wrapper from any program that currently has a sort or copy.

[Cliff Wiernik]

Are you using the local server? That appears to be what the error is saying?

[omni]

roger,

Forgot to mention one thing. The index on.. from the remote does work right. All other testing seems good also.

Thanks. I really appreciate your help.

Fred

[omni]

Roger,


On the text wrapper, what method can I use to pass the text to the wrapper. Not familiar with this.

For instance,

the passed text is "SELECT * INTO TESTOWNR FROM OWNER" as cADScommand

So you have the program lines:

TEXT INTO cSql WRAP

>insert cADScommand

ENDTEXT

Just not sure how to do that. Cannot use &cADScommand.

I am creating a single function to call from any current sort/copy.

Thanks

Fred

[rdonnay]

I don't understand what you are trying to do.

Do you mean this?

cSQL := "SELECT * INTO TESTOWNR FROM OWNER"

[omni]

Played golf today and I think it just made me slow...

Yes, that is all I need to do.

#(*&#($(

[rdonnay]

Played golf today and I think it just made me slow...

That's why I don't play golf.

[omni]

Roger,

Starting to convert and using all the different sql commands with my new function is working fine.
One issue I have run into is once the file is created, some of the programs open it exclusive due to either creating indexes or quick updates and bypassing file locking.
Getting a share error when this happens. Is there a setting to be able to open a newly created work file exclusive in ADS that you are aware of. I can get around it by using idx indexes and adding locking , but would like to avoid having to rewrite any more that I have to.

Thanks

[rdonnay]

I don't understand.

If some of your programs are opening a file exclusive then you would, of course, get a sharing error if you try to open it from any other workstation.