sqlquery.exe

This forum is for eXpress++ general support.
Post Reply
Message
Author
bobvolz
Posts: 114
Joined: Sun Jan 31, 2010 11:25 am

sqlquery.exe

#1 Post by bobvolz »

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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: sqlquery.exe

#2 Post by rdonnay »

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?
The eXpress train is coming - and it has more cars.

bobvolz
Posts: 114
Joined: Sun Jan 31, 2010 11:25 am

Re: sqlquery.exe

#3 Post by bobvolz »

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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: sqlquery.exe

#4 Post by rdonnay »

Try putting Administrator=No in your sqlquery.ini file.
The eXpress train is coming - and it has more cars.

bobvolz
Posts: 114
Joined: Sun Jan 31, 2010 11:25 am

Re: sqlquery.exe

#5 Post by bobvolz »

Excellent. That makes it easy.
Thanks

Bob

bobvolz
Posts: 114
Joined: Sun Jan 31, 2010 11:25 am

Re: sqlquery.exe

#6 Post by bobvolz »

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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: sqlquery.exe

#7 Post by rdonnay »

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.
The eXpress train is coming - and it has more cars.

bobvolz
Posts: 114
Joined: Sun Jan 31, 2010 11:25 am

Re: sqlquery.exe

#8 Post by bobvolz »

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

Post Reply