Search the web
Sign In
New User? Sign Up
PowerObject · PowerBuilder / PFC Developers' Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Fw: MYSQL function   Message List  
Reply | Forward Message #26574 of 27014 |


Hi guys,

I use a simple select statement " select count(*)  from my_table" which works
well in design mode. When i call it during run time " select count(*) into :li_i
from my_table", i always receive an error message telling my_db_name.count()
doesn't exist. Is there a default database name that must be called during run
time to access such a function?

Regards,

Hatem








[Non-text portions of this message have been removed]




Sat Jul 4, 2009 2:14 pm

hatem2507
Offline Offline
Send Email Send Email

Forward
Message #26574 of 27014 |
Expand Messages Author Sort by Date

Hi guys, I use a simple select statement " select count(*)  from my_table" which works well in design mode. When i call it during run time " select count(*)...
hatem esmat
hatem2507
Offline Send Email
Jul 5, 2009
4:26 pm

Check whether you have necessary rights to execute that query against that table. Sivaprakash ... From: hatem esmat <hatem2507@...> Subject:...
BKR Shivaprakkash
sivakrith
Offline Send Email
Jul 6, 2009
8:29 am

add option: 135168 to your Sqlca.dbparm connectString.. Like the example below // Profile ssisdev SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = False SQLCA.DBParm =...
Rolando
repeted
Online Now Send Email
Jul 6, 2009
3:06 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help