Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS
-
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) " & _
") " -
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) " & _
") "Some info[^] on how to use AutoInc fields in dBase. Sorry, forget that, wrong version.
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Some info[^] on how to use AutoInc fields in dBase. Sorry, forget that, wrong version.
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Oh bugger. I forgot to check the version.
Wrong is evil and must be defeated. - Jeff Ello[^]