Search found 28 matches

Go to advanced search

by Deraman
Mon Apr 18, 2022 6:39 pm
Forum: General Discussion
Topic: how to use hidapi please help
Replies: 6
Views: 1224

Re: how to use hidapi please help

Dear I tried both options but was not satisfied that is why asking for this lib.
Thanks
Deraman
by Deraman
Sun Apr 17, 2022 10:11 am
Forum: General Discussion
Topic: how to use hidapi please help
Replies: 6
Views: 1224

how to use hidapi please help

Dear anyone can help me in using
https://github.com/signal11/hidapi
https://github.com/libusb/hidapi
thanks
Deraman
by Deraman
Mon Dec 16, 2019 2:43 pm
Forum: Coding Questions
Topic: COMatePLUS....excel save as PDF
Replies: 0
Views: 1108

COMatePLUS....excel save as PDF

Dear, I need to save excel file as PDF. Do we have such option in ExcelFunktion/COMatePLUS?

following is powershell script which can do quite similar...


$path = “F:\”
$xlFixedFormat = “Microsoft.Office.Interop.Excel.xlFixedFormatType” -as [type]
$excelFiles = Get-ChildItem -Path $path -include ...
by Deraman
Sun Dec 15, 2019 7:13 am
Forum: Coding Questions
Topic: accessing PDFcreator from Purebasic
Replies: 1
Views: 1341

accessing PDFcreator from Purebasic

Dear, Can anyone help me in accessing PDFcreator from Purebasic?
https://www.pdfforge.org/
http://download.pdfforge.org/download/pdfcreator

One way is Command line
and other is COM interface

The folder of PDFcreator uploaded to my google drive where you can find all..
https://drive.google.com ...
by Deraman
Thu Apr 05, 2018 12:14 pm
Forum: Coding Questions
Topic: using network library of PB
Replies: 7
Views: 2401

Re: using network library of PB

Dear, I did some codding (from examples), worked but please make it more professional.
Thanks
;NewMap RecData.s()
OpenWindow(0, 100, 200, 200, 100, "Echo Server", #PB_Window_SystemMenu | #PB_Window_MinimizeGadget )
If InitNetwork() = 0
MessageRequester("Error", "Can't initialize the network !", 0 ...
by Deraman
Thu Apr 05, 2018 10:49 am
Forum: Coding Questions
Topic: using network library of PB
Replies: 7
Views: 2401

Re: using network library of PB

Dear, Thanks! I was only checking client example...please suggest me, I like to listen on specific IP:port...which one I use?
I have to connect ESP-LINK
https://github.com/jeelabs/esp-link

Thanks
deraman
by Deraman
Thu Apr 05, 2018 8:51 am
Forum: Coding Questions
Topic: using network library of PB
Replies: 7
Views: 2401

Re: using network library of PB

Dear, There is no event handling, to be specific, I need example with
https://www.purebasic.com/documentation ... event.html
Thanks
deraman
by Deraman
Thu Apr 05, 2018 8:27 am
Forum: Coding Questions
Topic: using network library of PB
Replies: 7
Views: 2401

using network library of PB

Dear, I need nice server and client example for TCP/IP with PB library and event triggered/captured.
Thanks
deraman
by Deraman
Thu Dec 21, 2017 2:47 pm
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

Re: sqlite DatabaseQuery....function SUM(

Thanks
done

Code: Select all

    For x=1 To 8
      If DatabaseUpdate(0, "CREATE TABLE "+"MACH"+Str(x)+" (Date INT);"):EndIf
          DatabaseUpdate(0, "ALTER TABLE "+"MACH"+Str(x)+" ADD COLUMN Fault INT;")
    Next x

why it worked without brackets?
by Deraman
Thu Dec 21, 2017 2:18 pm
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

Re: sqlite DatabaseQuery....function SUM(

Dear, really appreciate your help!
I stuck again, so need help!!
Trying to column in existing table...

For x=1 To 8
If DatabaseUpdate(0, "CREATE TABLE "+"MACH"+Str(x)+" (Date INT);"):EndIf
DatabaseUpdate(0, "ALTER TABLE "+"MACH"+Str(x)+" ADD COLUMN (Fault INT);")
Next x

Thanks
deraman
by Deraman
Wed Dec 20, 2017 4:25 pm
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

Re: sqlite DatabaseQuery....function SUM(

Thanks to all!

I saved date in column1/fault1 as quad .... converting date to quad value as...

Code: Select all

Date$ = FormatDate("%yy%mm%dd", Date())
x.q=Val(Date$)

make queries like

Code: Select all

DatabaseQuery(0, "SELECT SUM(fault2) FROM MACH1 where fault1 between 10 and 15;")
worked!

thanks
deraman
by Deraman
Thu Dec 14, 2017 1:28 am
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

Re: sqlite DatabaseQuery....function SUM(

Dear, Thanks!!! :P

If DatabaseQuery(0, "SELECT SUM(fault2) FROM MACH1")
NextDatabaseRow(0)


actually solved my problem....thanks you all again...

Now one more issue...
I like to add Date column and filter data with date range...
....WHERE DateStart >= dd/mm/yy AND DateEND <= dd/mm/yy
Really ...
by Deraman
Wed Dec 13, 2017 3:44 pm
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

Re: sqlite DatabaseQuery....function SUM(

Thanks! but did not worked. My full code

UseSQLiteDatabase()
Filename$="testing.sqlite"
If CreateFile(0, Filename$)
Debug "Database file created"
CloseFile(0)
EndIf
If OpenDatabase(0, Filename$, "", "")
Debug "Connected to PureBasic.sqlite"
If DatabaseUpdate(0, "CREATE TABLE MACH1 (fault1 ...
by Deraman
Wed Dec 13, 2017 3:01 pm
Forum: Coding Questions
Topic: sqlite DatabaseQuery....function SUM(
Replies: 12
Views: 3188

sqlite DatabaseQuery....function SUM(

Dear, I urgently need help in sqlite...I like to use DatabaseQuery for function SUM(column)
I tried some thing like....without success...
Debug DatabaseQuery(0,"SELECT * SUM(column1) FROM Table1;")....gives me 0
Debug DatabaseQuery(0,"SELECT * ,SUM(column1) FROM Table;").....gives me 1

Thanks ...
by Deraman
Thu Sep 28, 2017 8:35 am
Forum: Applications - Feedback and Discussion
Topic: ComatePlus + Excel set active sheet
Replies: 2
Views: 3028

ComatePlus + Excel set active sheet

Dear, I badly need to add sheets and make one of them active using ( ComatePlus + Excel )for transferring data. Please suggest.
Thanks
Dearman

Go to advanced search