Recent content by nikeloeleven

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....