[SOLVED] Problem grid - SQL statement with global variables

Scriptcase 7 Bugs
#1

when you have global variables in the WHERE
Example:
SELECT numfact, date, code, numfact FROM facturas WHERE value = [glnumfact]

When I run the following error displays:

Parse error: syntax error, unexpected T_STRING, expecting ‘]’ in C: \ NetMake \ V7 \ wwwroot \ ScriptCase \ app \ xxxxxx \ grid_nnnnn\ grid_nnnnn_grid.class.php on line 367

Please your urgent assistance

#2

The missing ] will probably be the problem … In your post is it, but in your code? I use global variables in where-clauses constantly …

#3

Yes, I use this construction continuously too, but I have not upgraded yet to 7.1 So it might be an issue or perhaps the global variable is containing a ‘[’ ?

#4

Hello,

Do you have any global variables set on your events? Could you comment all events to make sure the issue isn’t being caused by any event?

regards,
Bernhard Bernsmann

#5

Hello,

It is the only global variable defined in the grid.

regards

#6

Good afternoon,

I proceeded to perform the upgrade ScriptCase and this problem is solved.

Thanks …

#7

Thanks for your feedback.

regards,
Bernhard Bernsmann