Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    8

    Unanswered: Where can I download get version 7 of pervasive

    Where can I download version 7 of pervasive. It has to be version 7 since I need to create note fields, since their size is 0 in the data files and the record is variable length, but in version 8 the longvarchar fields are a length of 8 bytes. I want to also create the sql scripts to create the tables
    i.e. create table cusomer in dictionary ...

    and version 7 enables you to do this

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Actually, you don't need version 7. You can use DTO or DTI to create the table definition for the Note field. I'll see if I can throw some code together...
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Here's some DTO VB code I just threw together. I tested with Pervasive.SQL V8.5 and it created a table with a Note field..
    GOod luck..
    Code:
    Dim m_dtoTable As New DtoTable
    Dim m_dtoDictionary As New DtoDictionary
    Dim result As dtoResult
    result = m_dtoDictionary.Open("c:\pvsw\demodata")
    If result <> Dto_Success Then
        MsgBox "error opening table. Error code: " & CStr(result), vbCritical, "Error"
    Else
        Dim m_dtoColumns As New DtoColumns
        Dim m_dtoIndexes As New DtoIndexes
        Dim m_Column As DtoColumn
        Set m_Column = New DtoColumn
        With m_Column
            .Name = "IntField1"
            .Size = 4
            .Type = dtoTypeInteger
        End With
        result = m_dtoColumns.Add(m_Column)
        If result <> Dto_Success Then
            MsgBox "Error adding column 1. Error code: " & CStr(result)
            Exit Sub
        End If
        Set m_Column = Nothing
        
        Set m_Column = New DtoColumn
        With m_Column
            .Name = "strField2"
            .Size = 10
            .Type = dtoTypeString
        End With
        result = m_dtoColumns.Add(m_Column)
        
        If result <> Dto_Success Then
            MsgBox "Error adding column 2. Error code: " & CStr(result)
            Exit Sub
        End If
        
        Set m_Column = New DtoColumn
        With m_Column
            .Name = "noteField3"
            .Size = 3000
            .Type = dtoTypeNote
        End With
        result = m_dtoColumns.Add(m_Column)
        
        If result <> Dto_Success Then
            MsgBox "Error adding column 2. Error code: " & CStr(result)
            Exit Sub
        End If
        
        Dim m_Index As New DtoIndex
        With m_Index
            .Name = "idx1"
            .Number = 0
            .Flags = dtoIndexDuplicatesAllowed + dtoIndexModifiable
        End With
        result = m_dtoIndexes.Add(m_Index)
        If result <> Dto_Success Then
            MsgBox "Error adding index. Error code: " & CStr(result)
            Exit Sub
        End If
        
        m_dtoTable.Name = "noteTest"
        m_dtoTable.Columns = m_dtoColumns
        m_dtoTable.Indexes = m_dtoIndexes
        m_dtoTable.Location = "notetest.btr"
            
        result = m_dtoDictionary.AddTable(m_dtoTable)
        If result <> Dto_Success Then
            MsgBox "Error adding table. Error code: " & CStr(result), vbCritical, "Error"
        End If
    End If
    MsgBox "Done"
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  4. #4
    Join Date
    May 2004
    Posts
    2

    Red face Betrieve Database

    Anybody has betrieve database software??

    i want to develop software on betrieve database.

    if anybody has software or link of that software Pls help me.

    Thanks.

  5. #5
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Got to www.pervasive.com. There's a trial version available there.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •