Search results for query: *

well i had a look at the datatype for my admission number field and it says Char(6) in interbase..... surely that must mean that it is searching for a string right???

TNew2Delphi and svanels >>> yes i did try the hardcode "a11889" and it still gave me that error.... If i try ...... "where admissionnumber = 12" or any other number then the program works without any errors... but if i try a value with characters then the program gives an error...

Hi... i've done a little more testing and ive found out that the mistake probably lies somwhere here : + maskAdmissionNumber.text + <<<<<< if i enter another value into the text box then the error message will say that the value entered is an unknown column... therefore... it must probably...

Well what i've actually done is made a new module where i've added all the Interbase connections for the database and also placed a TIBQuery.... The TIB query is directly connected to the TIBDATABASE component... (Do i need any other SQL component other than the TIBQUERY ???) i've left the SQL...

Hi svanels... i used a text field with number intelligence because it is a joint primary key (along with target number) :) But why is the program looking for a column named A11889 when A11889 is actually the primary field that I am trying to find from the ADMISSION NUMBER column.... I have...

hi there.... im using a very simple Select Statement in Delphi... I have a table called "TARGET".. the unique field is Admission Number (of pupil) and Target Number.... the database is an interbase database constructed using SQL... I have placed an SQL query such as this to retreive some...

hi.... well i could use the sql statements to do this but i've been told that this requires me to fiddle about with the dataset quite a bit? is this true???? also, in order to use the sql statements in my delphi program, do i have to use some special feature or can i simply just add in the sql...

Hi there.... I have a table called TARGET. Every school pupil has to set himself/herself 3 tasks.... Therefore, the key fields in this "target" table are Admission Number and Target Number.... I have added a search facility in my forms so that you can search for the targets.... you can...

hi here's my Code to locate a record in a table called PUPIL dataModMain.tblPupil.Locate('AdmissionNumber',editAdmissionNumber.text,LoPartialKey); For some reason, when I try to compile, I get this error message: Undeclared Identifier "loPartialKey".... Is there a command that I need to add...

hi thanks for the help... I tried the FAQ but it didn't work... on top of that... Delphi doesn't recognise "FindNearest" from: try table1.FindNearest(edtSearch.text); it says "undeclared identifier".... Overall... the coding in the FAQ didn't work for me... What I would like to solve is this...

Hi there... I have a program in Delphi and an Interbase database linked... I have a datamodule (called unitDataModMain) where i keep the Interbase data connections.... I have a table called "Pupil" (the table connection is called tblPupil) which stores the details of pupils: Amission Number...

Hi there, I have a database called IPM.gdb.... It is made in Interbase so i used Interbase controls to connect the database to delphi...one of the Tables is called "StaffMember" It has 4 fields: StaffID Forename Surname StaffGroup...

Hi... im using a MaskEdit box to allow users to enter details... but the format must be like this: "A-1-Number-Number-Number-Number" The first character must be A, the second character must be 1.... then the last four characters can be any numbers".... I can get the last four characters to be...

im sorry for asking so many questions i do not have an iterbase manual but im trying to get one ive searched on the net for some of my problems but its hard to find what im looking for thnx

what's a check constraint... and how does it work please....

can you explain to me how you make and use an integer key.... it would be helpful if it auto incremented like in Access...

Also, can you please explain to me where a Char should be used instead of Varchar... and shall i use Varchar instead of Char when the field description doesn't have "not null"?

Well this system is for a school. I'm assuming there will never be more than 99 staff members in a school. Shall I therefore use Char(3) or is there another datatype you recommend Geoff?

Hi there, i'm going to have primary fields for my database fields such as "Staff ID" where the IDs will be something like "S01" "S02" "S03" etc.... what datatype would you recommend using for this type of field??? I'm guessing Char because the field sizes will consistently be the same...? Thanks

thx a lot:) but i dont want the user to be able to enter any more values other than progressing or completed so how will char do this?