INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

CLARION 6.EE BUILD 9053 {PROP:SQL}

CLARION 6.EE BUILD 9053 {PROP:SQL}

(OP)
Someone has to know what's happened with table{PROP:SQL}= SELECT... after Clarion 6.3EE build 9053? I have code:

table{PROP:SQL}= 'SELECT field1, field2 from table1';

After Clarion update to build 9053, 54, 55 ... to 59 this sentence doesn't work. Any ideas?

Thank you.

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

Maybe conversion changed dictionary table to not SQL driver ?
What is errcorode number and FILEERROR() ?

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

(OP)
Uniglass, thank you for your response.

No errors, Dictionary is OK.

Firebird 2.5
Firebird_ODBC_2.0.0.151

Clarion 6EE build 9052

This code works:

TEMP_INTEGER{PROP:SQL} = 'select rb from objekti_foto where id_objekta = ' & clip(BRW1.q.OBJEKTI:ID)

if error() then
message('ERROR 1 ' & error())
END


Clarion 6EE build 9053, 54, 55, 56, 57, 58 and 59 dont work but no errors

*************************************************************************************
For Clarion 6EE build 9053 and more this the following code is good but I would like take previously

TEMP_INTEGER{PROP:SQL} = 'insert into temp_integer(id) select rb from objekti_foto where id_objekta = ' & clip(BRW1.q.OBJEKTI:ID)

if error() then
message('ERROR 1 ' & error())
END


Best regards, Marko

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

So instert works.
1. Do you use NEXT(TEMP_INTEGER) after select ? ;)
2. Does first field of TEMP_INTEGER match rb type ?
3. Try objekti_foto{PROP:SQL} = 'select * from objekti_foto where id_objekta = ' & clip(BRW1.q.OBJEKTI:ID) and check if it works.

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

(OP)
Interestingly, I am totally confused!????

After SELECT I have SET, LOOP, NEXT and now when I turned off the set(TEMP_INTEGER) everything works perfectly.

! set(TEMP_INTEGER)
loop
next(TEMP_INTEGER)

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

hmm... I never use SET() with {Prop:sql}. Examples in help manual don't use it either.

RE: CLARION 6.EE BUILD 9053 {PROP:SQL}

(OP)
Definitely mystery was resolved.
Sometimes not bad read manual (RFM definition).
Uniglass, thank you for support.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close