Morning Programmers
I have given project where there is corrupt database in the form of text file , what they need is paradox Boland c++ database that will handle the duplicates of student no and make it primary key on the student table. What i have done so far i was able to extract student no from the file but when i save to my field student_No(Prim ary Key), Error message pop up Key Violation.
My Question...
Walter Thizo
Last Activity: Nov 14 '08, 12:15 PM
Joined: Oct 15 '08
Location:
-
Key Violation(Urgenlty)
-
That is what i code
INSERT C.CustName,O.Or derDate
INTO Customer C , Order O
WHERE O.OrderNo=C.Ord erNo
VALUES ('Lee','20/11/2008')
Correct me because i haven't test as my SQL Server is not working at moment. -
Removing Duplicate within listbox
I have substring the duplicate different records from file and i want to load those records inside listbox or paradox table distinctly -
This is records from file :
Student No
2001
2001
2001
3002
3002
The solution that i want must do these:
ListBox
2001
3002
Than... -
SQL Data Manipulation
I am new i SQL and i want to update,insert and delete using multiple related tables for instance
Table 1 and Table 2 - When i update table one also the related field in table 2 must be updated ...
Thanks -
-
-
Jos , it is C++ and all i want is a logic of how can i use getline function to solve my problem because I did use getline fuction to read all records inside the text file .So pls can u give me the logic
Kind Regards...Leave a comment:
-
I appreciate your respond but look what i did (Code below)-
//loop through the file
for (int x=0 ; x < 21 ; x++)
{
//read the first line and delete
Space = OneFileLine.Pos ("-");
IDStud = OneFileLine.Sub String(1,Space-1 ) ;
OneFileLine = OneFileLine.Del ete(1,Space );
Comma = OneFileLine.Pos (":");
StudSurname = OneFileLine.Sub String(1,Comma-1...Leave a comment:
-
Substring Text File
Hi Programmers
Look at the text files below -
............... ............... ............... ............... ............... ............... ............... .......
18-JUL-2008 11:10 JOKOTO UNIVERSITY Page : 1
Dept : 6601 - BUSINESS INFORMATICS
Subject : IDC30AE - INDUSTRY EXPOSURE IIIA
Class Group : A
Responsible... -
In addition to what they have said depending on the project ,if project is Web based recommnedation will be Java as it contains powerful features for Web application or ASP.Net with Java or C# but if the project is Windows based when i said windows based i mean like application for finance or billing within the organization recommendation will be C++ or VB.Net .
Kind Regard
WalterLeave a comment:
-
Design pattern
Hi developers
i am busy with the course OO analysis and design ,so my problem is i don't understand design pattern such as Singleton,Adapt er and Observer anyone with practical explanation ,i will appreciate the answer -
when i try to test you code ,it generate more than one error such as this ones :
[C++ Error] Unit1.cpp(63): E2356 Type mismatch in redeclaration of 'findAverage(do uble *,double)'
[C++ Error] Unit1.cpp(5): E2344 Earlier declaration of 'findAverage(do uble *,double)'
for the error Type mismatch it caused by function
[double findAverage (double [], double);]
it does n't match with...Leave a comment:
-
searching in listbox
i am developing the database application and using database in the form of text file, so i did load the text file to listbox but now my problem is the alignment of the records inside the listbox and also i want to search the records from the listbox so that i can load to paradox table ? any idea please
No activity results to display
Leave a comment: