Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 23rd, 2024, 3:06 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Access DB Connection Issue with Text Input Box
PostPosted: May 13th, 2010, 6:15 pm 
Offline

Joined: April 8th, 2005, 5:35 pm
Posts: 2
Location: PA
Hi,
I have created a connection using Opus to a local access database. I have 4 pages Add, Search, View and Update.
Some of the text input boxes I'm using on the add a record page will not always need to be filled in. If one or any of the text input boxes are not filled in I receive a error stating this box cannot contain 0 string. the addition is not submitted. Can I do some thing to the text input boxs to allow me to add a record even if a input box is not filled in? Thanks for any help.


For this message Charles has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Access DB Connection Issue with Text Input Box
PostPosted: May 21st, 2010, 12:39 pm 
Offline

Joined: November 25th, 2004, 1:24 pm
Posts: 512
Location: Scotland
Opus: 9.75
OS: Win 10
System: Asus i7-7700K 16Gb
I think this may be related to your database not being able to have an empty string? have you put some kind of constraint on the entry in access?

If you have a text input in Opus, you have to allocate a variable to it, so I don't think it will return a null, just an empty string


One way you can test.......is to edit the variable for the text input, give it a default value, either a number or text. it will return the default value (assuming you don't clear the entry first).
If you edit a variable, remember to hit the APPLY button otherwise it won't do the change. An altarnative is to test if nothing has been entered in the text entry, then substitute the empty string for "ABC123" or anything you know is a valid entry.?

_________________
Whoever designed this, never actually used it!


For this message sandyn has been thanked by : mackavi


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 48 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group