Re: Table validation

[Jim Idle]

Williams wrote: I posted the request below but no one seems to help.  I still need the help please!!! Well, the issue here is very likely that your description provides no real information about your question. So little in fact that I almost moderated this away. First, you need to read the posting guidelines: http://groups.google.com/group/jBASE/web/Posting%20Guidelines Try reading the question back to yourself and assuming that you don't know any details about what you are doing. Firstly, we don't even know that your target database is jBASE, as you don't say this, don't give a version number and refer to files as tables. We don't know what operating system this is, which may or may not be useful information (how do you know?). Next, if we assume that you are using jBASE, then we don't know which of the possible languages you could be using and needing to verify with. Are you using Proc? jQL query? jBC? C? Java? Some T24 configuration screen? A 4GL? Next, you don't say what you mean by verification, though given that we don't know what language you are trying to use, may not help anyway. Do you mean referential integrity, you mean that but don't know the meaning of that phrase, you mean that when a value for a field is entered, you need to read the other record and verify it is a valid input, you want to flag an error if the record doesn't exist in BBX? In fact, you say that you "want to validate table BBX", and not the input field. The fact that you use 'input' implies user data entry, but is this over the web, in a local program? Do you really mean that you want to validate table BBX or that you want to use table BBX to validate that the field recorded in the record of table AXX is a valid field because it is only valid if there is a record in table BBX whose ID is that of the field in table AXX. I think that you put so little thought into your question, that basically people ignored you. So, go read the posting guidelines and repost your question, but this time ask an actual question ! :-) This is a trivial question for most of the languages you could be using, but nobody has anything to go on, otherwise you would have had about 50 answers to this one already, I assure you. DOn't worry about correct English, just get the pertinent facts on the table. Jim   Williams From: Williams <wadefi...@yahoo.co.uk> To: jBaseGroup <jBASE@googlegroups.com> Sent: Saturday, 31 January, 2009 16:00:09 Subject: Table validation I need suggestion on how to achieve this please. I have two tables, AXX, and another table BBX.  There is a field in AXX table that is the ID of table BBX.  I want to validate table BBX whenever an input is made to this field on AXX.  Can anybody help me please?   Williams --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---