PureBasic Forums - English

After a bit more reading up i think it's because it's a malformed link E.G not a regular web page like "https://www.google.com" This poses a problem in that previoulsy i could put any old information in the link, then parse it and act on it E.G the id of the record selecteed and then open ...

Hi, So i use the webgadget for displaying some table data and I've always used hyperlinks to open windows to display more info on specific items in the table. Since playing around with the recent betas and using the #PB_Web_Edge flag the hyperlinks return about:blank#blocked whereas they used to ret...

oops - ignore that. :oops: But no doesn't work for any of them. I'm doing some more experimentation at the moment and i think it's the version of the ODBC driver - if I upgrade to the newest it works fine, but in this particular use case i have to use an older 32bit version which this doesn't work w...

Thanks Spikey,

Gave me an excellent start and works like a charm

cheers

; Execute a SQL query If DatabaseQuery(0, PVAR_sql) column_count.i = DatabaseColumns(0) ; get the column names and update the CSV For loop_count = 0 To column_count Debug DatabaseColumnName(0, loop_count) Select DatabaseColumnType(0, loop_count) ; Case #PB_Database_Long ; Numeric format (a Long (.l...

Morning all,

Not sure if this is a bug or known behaviour :

On the latest beta DatabaseColumnType() returns 0 when using ODBC as a connection type.

I will test it using older versions but wondered if anyone else has seen this before.

Cheers

Hi spikey, So normaly i retrieve a limited record set using the LIMIT and OFFSET paramters in the underlying SQL query, I then have First, Previous Next and Last page navigation buttons to move through all the data in the recordest. I only use this for large recorsets though. However in my particula...

Hi,

Has anyone got or can point to an example of dynamicaly loading data into a listicongadget when scrolling up or down ?

I can't use pagination in this particular usage case but want to speed up load times from the database.

Any help appreciated

Cheers

RSBasic wrote: ↑Thu Jan 04, 2024 2:44 pm Hello captain_skank

HTML code is used by default. I.e. if you want to insert line breaks: <br>

Sorry for the delay in replying, works like a charm.

Thanks muchly.

Hi and a Happy 2024, Going to sound like a silly question, but when using : Result = SendMailEx(ID, Subject$, Body$, Priority, From$, ToAddress$, CC$, BCC$, Attachments$, @ErrorOutput$) How do format the text for the Body$ ? I thought using #crlf$ would insert linebreaks but it doesn't. Any help app...

I can, but i'm up to my eyes in an equipment audit at the mo, so may be a few days + i want to tidy up and add a few other things before i post it.

N.B : In the end i found it easier to plot and calculate using a right angled triangle

Thanks very much stargate - works like a charm.

I need to measure an angle of something in an image. Loading the image etc - no problem. Plotting the 3 x,y points and overlaying the 2 lines to highlight the angle - no problem How do i then calculate the angle described by the 2 lines ( math especialy trigonometry is not my strong point ) I know i...

Hi Denis, You could take a look at the following to maybe start you off with Sqlite & Purebasic, or do a search for YADA. https://www.purebasic.fr/english/viewtopic.php?p=557322&hilit=YADA#p557322 Personally, I don't think that Purebasic is very productive, or advisable to use in creating a...

I gave up on this in PB and do it all on the MySQL/MariaDB backend - saved me end of trouble, especially when dumping in to Excel.