Stored Procedures and double quotes in wonderware

Join Date
Jan 2003
Location
Michigan
Posts
490
Hello All,
Im trying to pass an argument to a stored procedure in wonderware. Someone else is doing the data base, and im required to do a SQLSelect on the stored procedure passing it one argument. The argument is a string (from a tag). They are using firebird for the database. Their example is
Select LoadTemp, LoadTime, QuencTime1, QuenchTime2 from GetLoadNumberInfo("1000")

I cant put that in my sqlselect cause the " ends that part of the satement.

The "1000" string is the argument. Is there a way to do this? Ive looked at the setstatement function, but that seems to be just for SQLExecute and not SQLSelect. Thanks

matt
 

Similar Topics

Hey Everyone, I need some assistance from some good HMI programmers. I have been asked to make some changes to the HMI on one of our Packaging...
Replies
0
Views
950
Hello, In CLX5000 I have a DINT being used to store the shift's break time as a whole number ie 1:00 would be 100. The issue is if I want to...
Replies
32
Views
8,703
Hi All, Could someone please shine some knowledge on how i go about correctly storing the recipes onto the sd card using the recipeplus in...
Replies
0
Views
1,100
Hi. I'm a beginner at programing and my question is about the MOV instruction at RSLOGIX. First of all I dont have any practicals issues with...
Replies
8
Views
3,380
Hey everyone, I have a Keyence LK-G5001P control module with 2 laser heads connected to it (the lasers are Keyence LK-H152). I have the control...
Replies
3
Views
2,176
Back
Top Bottom