IT Forums - Basing a Data Block on a Select Query

Hassan Ayub

09-11-2004, 12:02 PM

Hi Folks,

I'm trying to create a data block in Forms 6i, based on a from clause
query which I give in the Query Data Source Name Property of the data
block, but when I run the form the fields are blank and even when I
execute the unrestricted query from the forms runtime environment, the
fileds are still not populated and FRM-40505 error is given. Am I
missing some basic stuff here?

TIA

Hassan

Marino Ljubic

09-13-2004, 05:57 AM

"Hassan Ayub" <hassan_ayub@yahoo.com> wrote in message
news:1df2b71.0409111202.265d6f86@posting.google.com... Hi Folks, I'm trying to create a data block in Forms 6i, based on a from clause query which I give in the Query Data Source Name Property of the data block, but when I run the form the fields are blank and even when I execute the unrestricted query from the forms runtime environment, the fileds are still not populated and FRM-40505 error is given. Am I missing some basic stuff here? TIA Hassan

Hi,
Maybe you are. What does "Display Error" say?

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service