Oxygen Basic

Information => Open Forum => Topic started by: kryton9 on October 19, 2011, 10:04:03 PM

Title: does someone have a copy of my sqlite class?
Post by: kryton9 on October 19, 2011, 10:04:03 PM

I realized when I reformatted my computer, I had not backed up my sqlite class that I had made. Does anyone have a copy of it, or do you have a working copy of my help .chm file from the link below. It has the source for the class.

Another strange thing... I remembered I had all the source code in my .chm help file I had made with HelpNDoc. I downloaded the one I uploaded to the forums. It opens fine, but there is no content inside the .chm? But from the posts, it seemed like you guys were seeing the content on your downloads.... that one has me perplexed.
http://www.oxygenbasic.org/forum/index.php?topic=306.0

Title: Re: does someone have a copy of my sqlite class?
Post by: Charles Pegge on October 20, 2011, 12:07:58 AM

Hi Kent,

Have you tried unblocking the downloaded chm: (icon right-click->properties->Unblock click)

Here is your sqLite class:

Code: [Select]

'SqliteC.inc
'SqliteC inc file

'Last modified:

'2011.07.05 06:37 KS




include once "ConsoleC.inc"




extern lib "sqlite3.dll"

    sys      sqlite3_open        ( zstring* name, sys*     db                               )

    sys      sqlite3_exec        ( sys      db  , zstring* s, sys p1, sys    p2, sys* dberr )

    sys      sqlite3_prepare_v2  ( sys      db  , zstring* s, sys p1, sys* stmt, sys  p2    )

    sys      sqlite3_step        ( sys      n                                               )

    zstring* sqlite3_column_text ( sys      row , sys      col                              )

    sys      sqlite3_close       ( sys      db                                              )

end extern




#define SQLITE_ROW 100




class SqliteC

    private

        sys mHdb

        string mFile

        string mTable

        sys mError

        sys mStmt

        sys mRows

        sys mRow

        sys mClmn

        zstring* mErrMsg

        ConsoleC c

    public

        method Constructor( optional string aFile = ":memory:" )

            c.Constructor "SqliteC Console"

            mFile = aFile

            sqlite3_open mFile, mHdb

            if mError then PrintError

        end method

       

        method Destructor()

            if mHdb then

                sqlite3_close mHdb

                if mError then PrintError

            end if

            c.Destructor

        end method

       

        method Open( string aFile )

            c.Constructor "SqliteC Console"

            mFile = aFile

            sqlite3_open mFile, mHdb

            if mError then PrintError

        end method

       

        method Exec( string aCommand )

            sqlite3_exec mHdb, aCommand, 0, 0, mError

            if mError then PrintError

        end method

       

        method Qry( string aCommand )

            string s = ""

            sqlite3_prepare_v2 mHdb, aCommand, -1, mStmt, 0

            if mError then PrintError

        end method

       

        method Scan() as sys

            return sqlite3_step( mStmt )

            if mError then PrintError

        end method

       

        method CTxt( sys aColumn ) as string

            return sqlite3_column_text mStmt, aColumn

            if mError then PrintError

        end method

    private   

        method PrintError()

            c.SetColor F_WHITE or B_RED

            @mErrMsg = mError

            c.Print "ERROR: " mErrMsg "        " crlf$ crlf$

            c.SetColor DEFAULT_COLOR

            mError = 0

        end method

end class



Charles

Title: Re: does someone have a copy of my sqlite class?
Post by: Aurel on October 20, 2011, 04:58:33 AM

I just mean that you don't finish chm help and that because of this some topics are empty ???
Hmm i don't know what heapend...and as i say before i suggest you to use HelpMaker....
it is simply excellent tool for chm files...you must try ;)

Title: Re: does someone have a copy of my sqlite class?
Post by: Charles Pegge on October 20, 2011, 06:10:53 AM

CHMs are  treated by the OS as a security risk, so the Operating system blocks them until you explicitly unblock them in the properties panel.

Charles

Title: Re: does someone have a copy of my sqlite class?
Post by: kryton9 on October 20, 2011, 10:51:34 AM

Thanks Charles. Yes, the blocking in the properties was the problem.

Title: Re: does someone have a copy of my sqlite class?
Post by: Aurel on October 20, 2011, 11:22:59 AM

Hmm weird...i never have this type of problem on XP.
So ..Kent do you post updated chm ?

Title: Re: does someone have a copy of my sqlite class?
Post by: JRS on October 20, 2011, 12:31:17 PM

Quote

mm weird...i never have this type of problem on XP.

Microsoft started taking security more seriously when they released Vista.

Title: Re: does someone have a copy of my sqlite class?
Post by: efgee on October 20, 2011, 01:10:24 PM

Tested it on WinXP and had to unblock the chm file.
System is up-to-date with all "security patches for WinXP"

@Aurel
This only occurs with downloaded chm files.
(the downloaded file needs to have the chm extension; chm in zip files should be fine).

Title: Re: does someone have a copy of my sqlite class?
Post by: kryton9 on October 20, 2011, 06:11:35 PM

Quote from: Aurel on October 20, 2011, 11:22:59 AM

Hmm weird...i never have this type of problem on XP.
So ..Kent do you post updated chm ?

Aurel, unfortunately the version I had uploaded was not the most recent version. I lost that when I redid my computer. Charles had mentioned that SciTe and Help will be outdated when he creates his new editor in opengl for us. I am going to create a help database with sqlite3, this way I can export the data anyway I want in the future and keep it up to date easier.

Title: Re: does someone have a copy of my sqlite class?
Post by: Peter on October 21, 2011, 03:37:39 AM

Quote

I lost that when I redid my computer.

Hi Kent,

Never heard of 'REDID'. What means it?
I know only 'REDO'.

Title: Re: does someone have a copy of my sqlite class?
Post by: JRS on October 21, 2011, 06:11:13 AM

redid

Past tense of redo.

Title: Re: does someone have a copy of my sqlite class?
Post by: Peter on October 21, 2011, 06:44:03 AM

Thanks JRS.

redo a room, but  was ugly.
redid a room, much nicer.

is this correct?

Title: Re: does someone have a copy of my sqlite class?
Post by: JRS on October 21, 2011, 05:21:41 PM

Quote

is this correct?

Past tense means after the fact.

Title: Re: does someone have a copy of my sqlite class?
Post by: kryton9 on October 21, 2011, 07:19:57 PM

I redid the room last week. It is much nicer now.

I will redo the room next week.