bb.donnay-software.com

Hi;

Is there a parameter that can be passed to sqlquery.exe that will turn off the ability to edit a record.

I would like to be able to call this program from my app but for sorting and viewing and filtering only.

Bob Volz

I added this capability for another customer who calls Sqlquery() class from his code.

How are you invoking Sqlquery? Are you using RunShell() or the class?

Hi Roger; I use the class on some of my popular browsers but I also use runshell as standalone menu item for queries into some files.

Thanks

Bob

Try putting Administrator=No in your sqlquery.ini file.

Excellent. That makes it easy.
Thanks

Bob

Hi Roger; Not sure in the ini file where I should put the Administrator=No

This is the code I use for the runshell calling the SQLQuery.exe

Also not sure what the 2 .t. 's are for in the runshell.?

DCMENUITEM "&1.Service Customer SQL Query" PARENT oSequelMenu ;
MESSAGE 'Service Customer SQLQuery' ;
INTO oMsgBox ;
ACTION {|| RunInNewThread({|| RunShell('/co:ADS_3 /st:servcust','c:\automanads\sqlquery.exe',.t.,.t.)})}

[ADS_3]
TYPE=ADS
Name=f:\aman\aman.add
Database=f:\aman\aman.add
uid=AdsSys
AdsLockingType=1
AdsTableType=2
Administrator=No Do I put this here or in the [SYSTEM] section ??

Doesn't seem to work either way. Pressing enter stills gives edit screen.

Bob

It looks like this is going to require some major mods to my code to give you what you want.

I thought I already supported this for my other customer, but he didn't ask for that.
I wrote a bunch of mods to the SqlQueryConfig() class.
I could add your requirements too but then you will need to use the class instead of RunShell().
If I need to add all these configuration parameters to Sqlquery.ini, that's going to take a lot more work.

Hi Roger;

Don't worry about it. I will use the Class. I believe the editing is still controlled in the browse.

I'm going to remove the runshell options from my menus. I don't want people editing data outside my app.

Thanks
Bob