Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nikeloeleven
  • Order by date
  1. nikeloeleven

    strange and irritating Sql problem

    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???
  2. nikeloeleven

    strange and irritating Sql problem

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

    strange and irritating Sql problem

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

    strange and irritating Sql problem

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

    strange and irritating Sql problem

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

    strange and irritating Sql problem

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

    Difficult Question About Searching Multiple Records???

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

    Difficult Question About Searching Multiple Records???

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

    Quick Question About TLocate

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

    Question About Searchin From Databases

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

    Question About Searchin From Databases

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

    Storing details entered from a text field into a database table...

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

    Question about MaskEdit...

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

    Strange Question About Boolean Data Types In Sql...

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

    Strange Question About Boolean Data Types In Sql...

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

    Unique ID

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

    Unique ID

    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"?
  18. nikeloeleven

    Unique ID

    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?
  19. nikeloeleven

    Unique ID

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

    Strange Question About Boolean Data Types In Sql...

    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?

Part and Inventory Search

Back
Top