Click here to Skip to main content
15,395,065 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 6:56
professionalPIEBALDconsult23-Apr-14 6:56 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:00
MemberSyafiqah Zahirah23-Apr-14 7:00 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 7:19
professionalPIEBALDconsult23-Apr-14 7:19 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:25
MemberSyafiqah Zahirah23-Apr-14 7:25 
AnswerRe: SQL statement Pin
Eddy Vluggen23-Apr-14 6:57
professionalEddy Vluggen23-Apr-14 6:57 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:27
MemberSyafiqah Zahirah23-Apr-14 7:27 
AnswerRe: SQL statement Pin
TeddyLi26-Apr-14 1:33
MemberTeddyLi26-Apr-14 1:33 
QuestionCreate an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
jkirkerx21-Apr-14 11:03
professionaljkirkerx21-Apr-14 11:03 
I'm not sure if this is even possible. I'm trying to create a auto increment column for FID in this database file.
I was going to use SQL Server Express, but decided to just stick with the same format of the original program Account Mate for DOS, running low on quoted time for the project.

Any insight would be appreciated!
Dim m_path As String = Nothing
Dim dwXCode As Integer = registry_shared.read_HKCU_dataPath(m_path)
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_path & "; Extended Properties=dBASE IV"
Dim queryString As String = _
"CREATE TABLE ARCEMJN " & _
"(" & _
"   FID AUTOINCREMENT " & _
"   , FINVNO VARCHAR(10) " & _
"   , FCUSTNO VARCHAR(10) " & _
"   , FTRANSDATE DATE " & _
"   , FCONTACT1 VARCHAR(80) " & _
"   , FEMAIL1 VARCHAR(254) " & _
"   , FSTATUS BIT " & _
"   , FERRCODE VARCHAR(10) " & _
"   , FERRMESS VARCHAR(80) " & _
"   , FPDFPATH VARCHAR(254) " & _
") "

AnswerRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Jörgen Andersson22-Apr-14 3:59
professionalJörgen Andersson22-Apr-14 3:59 
QuestionRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Eddy Vluggen22-Apr-14 6:57
professionalEddy Vluggen22-Apr-14 6:57 
AnswerRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Jörgen Andersson22-Apr-14 7:28
professionalJörgen Andersson22-Apr-14 7:28 
QuestionC# Windows application: connection string to connect to remote sql server 2008 using windows authentication Pin
AshwiniSH21-Apr-14 3:23
professionalAshwiniSH21-Apr-14 3:23 
AnswerRe: C# Windows application: connection string to connect to remote sql server 2008 using windows authentication Pin
thatraja21-Apr-14 4:12
professionalthatraja21-Apr-14 4:12 
Questionwould you use RDLC? Pin
Jassim Rahma18-Apr-14 12:51
MemberJassim Rahma18-Apr-14 12:51 
AnswerRe: would you use RDLC? Pin
Mycroft Holmes18-Apr-14 13:33
professionalMycroft Holmes18-Apr-14 13:33 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 12:15
MemberJassim Rahma20-Apr-14 12:15 
GeneralRe: would you use RDLC? Pin
Mycroft Holmes20-Apr-14 12:54
professionalMycroft Holmes20-Apr-14 12:54 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 22:04
MemberJassim Rahma20-Apr-14 22:04 
QuestionOld school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 6:31
professionaljkirkerx17-Apr-14 6:31 
AnswerRe: Old school dbase II / clipper database, multiple left joins Pin
Jörgen Andersson17-Apr-14 10:38
professionalJörgen Andersson17-Apr-14 10:38 
General[SOLVED] Pin
jkirkerx17-Apr-14 10:49
professionaljkirkerx17-Apr-14 10:49 
GeneralRe: Old school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 11:03
professionaljkirkerx17-Apr-14 11:03 
QuestionSQL Query Pin
Syafiqah Zahirah17-Apr-14 6:00
MemberSyafiqah Zahirah17-Apr-14 6:00 
AnswerRe: SQL Query Pin
Richard Deeming17-Apr-14 6:59
mveRichard Deeming17-Apr-14 6:59 
GeneralRe: SQL Query Pin
Syafiqah Zahirah17-Apr-14 20:18
MemberSyafiqah Zahirah17-Apr-14 20:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.