If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Brilliant Database > Trouble With Queries

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Location: Huntsville, AL
Posts: 306
Trouble With Queries

With every step baby forward, I run into yet another roadblock with this program. I am attempting to use queries and even though one would think that this procedure is straightforward, I am finding it's behavior to be very convoluted and unpredictable.

I have a simple query set up that appears to work when I use manually type in a value of a variable into a field; however, when I use script to 'Set Field Value (text)', the value that appears is NOT the value I had selected and the query then gives incorrect results. I can type in a value, for instance, 'SE-200', and it behaves properly but if I select the same value using 'Records From Folder' Open Input, the resultant value is a four-digit number ('1279'). Why is this occurring and how can I get BD to insert the value that I actually selected into the field?
Thanks,
Daryl G
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Location: Ireland
Posts: 545
Can you upload an example so I can take a look at it?

Regards
James
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Location: Huntsville, AL
Posts: 306
James,
Thanks for you willingness to help but I am just about to the point where I am going to give up on Brilliant Database. This is an excellent tool for designing forms but it lacks too much in regards to coding/scripting. Attempting to do any analysis of my data is exceedingly difficult - even for a very simply analysis. After spending almost two months struggling to use BD (one month with V9.42 and three weeks with V10), I have little to show for my efforts... that coupled with absolutely zero technical support/correspondence from Brilliant Database! I foresaw some great usage and applications, however, the scripting of the program is not very intuitive plus I have seen a lot of bizarre behavior from the program. Granted, I am new to this platform but have many years of programming experience though that is certainly not working to my advantage here.

I should not have to post a question every time I attempt to do anything - yet that is exactly what is happening. I do, however, applaud this community for their eagerness to assist with answering questions and addressing problems. I have one more week remaining on my evaluation period and if communication with BD is still non-existent, I suppose I will look elsewhere.
Thanks,
Daryl G
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 130
Daryl
Don't give up.I am using BDB since version 4.5.It is really highly user friendly software.Only last couple of years their there is no support from the developer.Still once you master the BD I am sure you will develop your required programs in minutes.When you select a record through "record from folder" the result will not be a field value instead it will be record id.You store this in a variable.Again you format this variable with recordset field then you will get the result what do you need.Send your sample database.I will send you the correct script.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 78
If you select record you can not use it as value.
That number you see is record number.
Look at this file, it may help you to understand.
Attached Files
File Type: zip MyDB1.zip (35.1 KB, 25 views)
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Location: Huntsville, AL
Posts: 306
MacHeuS,
I certainly appreciate all the help you given me. Unfortunately, I cannot even open up this file that you attached. Am I the only one who is experiencing EXTREME frustration with this program? I would be very thankful for any help with what I need to do to open the file.

Why is this so difficult???

Daryl G
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 78
Look at this screenshots. This may help.
Attached Thumbnails
Trouble With Queries-wrong.jpg   Trouble With Queries-true.jpg  
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Location: Huntsville, AL
Posts: 306
MacHeuS,
Great. Thanks. I understand a little bit better. You also answered a question that I have not yet asked (how you make the actual value appear). Again, MacHeuS, I thank you sincerely for your help.
Daryl G
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On