PureBasic Forums - English

XCoder

I am using the code posted by Rashad to draw on the desktop. I am using PureBasic 6.20 (x64) on Windows 11 with the compiler option "Enable DPI aware executable enabled".
Sometimes the area inside the shapes is transparent and at other times the area inside the shapes is black. Is there a way of ...

XCoder

@infratec: Thanks for clarifying the issue.

XCoder

Thank you for your replies.

The issue was with using count.

By changing the SELECT statement from

searchQuery$="SELECT Title, Description, rowid, COUNT(*) FROM tblBooks"

to

searchQuery$="SELECT Title, Description, rowid, (SELECT COUNT(*) FROM tblBooks) FROM tblBooks"

as suggested by ...

XCoder

The following program has a function FindNext() to get the next row in a database and display it in a debug window.

EnableExplicit

UseSQLiteDatabase()

Enumeration;{
#MainWindow=10
#btnOpenDatabase
#btnFindFirst
#FindNext
#dBase
EndEnumeration
;}

Global searchQuery$="", Quit

Procedure ...

XCoder

Thanks for your suggestion Axolotl.

Following your suggestion I have tried the four possible combinations of 1's and 0's for my return values but these have had no effect.

I looked at "How to use streams" at https://learn.microsoft.com/en-us/windows/win32/controls/use-streams and realised that one ...

XCoder

I am trying to read a record from a sqlite database into a rich text editor control.

Here is the relevant part of the code I am using:
Procedure DBStreamOpenFileCallback(hFile, pbBuff, cb, *pcb)
Protected *pbRecordData = #Null, dwRecordSize.i=0, DataBaseContents$=""
Protected dwRead = 0 ...

XCoder

Btw. why not:
UseSQLiteDatabase("D:\!Updates\Programming\PB\DLL experiments\sqlite3.dll")
Then you don't need to do that lib stuff.
Or is there a complete new function inside?

The PB SQLite library does not provide all the functionality available in the latest version of the sqlite3.dll file ...

XCoder

@ mk-soft

Thanks, that has solved my problem.

XCoder

I wrote the following code to directly access the latest sqlite3.dll library to create a database:

DatabaseFile$ = "Temp.db"
sqlite3_dbHandle = 0

Lib = OpenLibrary(#PB_Any, "D:\!Updates\Programming\PB\DLL experiments\sqlite3.dll")
psqlite3_open = GetFunction(Lib, "sqlite3_open")
hResult ...

XCoder

I have updated the code in my earlier post for OCRing text on the screen so that it works correctly with x64 versions of Windows. The updated code may be downloaded by clicking the download link in my original post.

XCoder

Thanks for pointing out the bug. I have updated the code for the spelling checker and put the link to the updated code in my original post at https://www.purebasic.fr/english/viewto ... 92#p582792

XCoder

I have updated the advanced version of the spelling checker so that it works correctly with the x64 version of Windows (click the link in the first post to download it).

XCoder

Thanks, AZJIO

XCoder

Thanks, AZJIO

Unfortunately there is still an issue with pressing F1 to get help information in the PB IDE.

I suspect this may be a bug with the PB IDE. Hopefully Fred will be looking into it as mentioned in a previous post in this thread.

XCoder

@AZJIO:

CustomUDFs_TOC.hhc does not contain the name of the second file:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<HTML>
<HEAD>
<meta name="GENERATOR" content="Notepad++ & AutoIt ^_^">

</HEAD><BODY>

<OBJECT type="text/site properties"><param name="Window Styles" value ...

PureBasic Forums - English

Search found 69 matches

Re: Direct write or draw on desktop

Re: SQLITE: Issue with FindNext

Re: SQLITE: Issue with FindNext

SQLITE: Issue with FindNext

Re: Reading SQLITE records into a RTF control

Reading SQLITE records into a RTF control

Re: SQLilte issue when creating a database

Re: SQLilte issue when creating a database

SQLilte issue when creating a database

Re: Windows 10 OCR and Face detection

Re: SpellCheck lib/include (32bit and 64bit) - hunspell wrapper

Re: Spelling checker for a rich text editor

Re: Issue using DocMaker

Re: Issue using DocMaker

Re: Issue using DocMaker