Search results for query: *

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

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

Hi guys, I was using SQL to create a field called "StatusofTarget" (status of target) ..... i want the data type for this field to be boolean so that the boolean values can be set as either "COMPLETED" or "PROGRESSING"... but i realised that SQL in interbase doesnt recognise BOOLEAN data...

Hi there. I'm new to Sql as you may know from my previous threads...I've been trying to Index a few of my tables. I've searched everywhere but I havent been able to find out how to create an index on a table with more than one primary key i.e. joint primary keys. Here is my small database...

Hi I'm using Interbase to create a multi-user database. I'm fairly new to Interbase and SQL. I was creating a database as shown below: Create Database 'c:\IPMnterBaseBackbone.Gdb' user 'SYSDBA' Password 'masterkey'; Create Table SubjectTarget (AdmissionNumber VarChar(4)...

Hi there :), I have 3 tables "PUPIL" "SUBJECT TARGET" "REVIEW" Basically, each pupil has a target that he sets himself/herself. Those targets are reviewed, hence the 3 tables. Here is my entity relationship diagram to show how they are linked: PUPIL -------- 1 to many ------------ SUBJECT...