Search found 226 matches

by swan
Thu Aug 14, 2025 12:39 am
Forum: General Discussion
Topic: How to Check Database Connection is still valid?
Replies: 9
Views: 712

Re: How to Check Database Connection is still valid?

As a matter of interest "SELECT @@SPID;" is SQL Servers equivalent, a system function returns the server process ID (SPID) of the current user process.
Also "SELECT SESSION_ID();" a function returning the ID of the current session. For those using SQL Server.
by swan
Tue Nov 14, 2023 12:46 am
Forum: Coding Questions
Topic: Setting the date on a dategadget()
Replies: 7
Views: 1109

Re: Setting the date on a dategadget()

Try this:

Code: Select all

DateFromDatabase.s = "2023-11-14 17:00:00" ; datetime source
Date.s = StringField(DateFromDatabase, 1, " ") ; filter date only
SetGadgetState(#Date, ParseDate("%dd/%mm/%yyyy", Date))
by swan
Sun Jan 01, 2023 12:57 am
Forum: General Discussion
Topic: Xojo Developers
Replies: 18
Views: 5389

Re: Xojo Developers

I'm not a XOJO developer I got it for a small project recently. It will never draw me away from PB as my main package though.
Overall I didn't mind it except for it's enormous overhead, also can't see why it's so expensive. To each their own ....
by swan
Fri Sep 23, 2022 8:04 am
Forum: Coding Questions
Topic: ExplorerTreeGadget custom set top parent dir
Replies: 0
Views: 861

ExplorerTreeGadget custom set top parent dir

Hi guys,
With ExplorerTreeGadget I'm wanting to custom set the top parent directory or drive to list, example - "D:\temp\".
If it is possible I guess it would involve some API stuff (Windows), something I'm not great at.
Any help much appreciated.
Steve ....
by swan
Fri Aug 12, 2022 4:16 am
Forum: Off Topic
Topic: Does size matter !!!
Replies: 5
Views: 1280

Does size matter !!!

Recently I was asked if I was interested in completing a project that was about two thirds along, done in RealBasic (Xojo). Target was for Windows desktop, not too complex with remote DB. Not knowing too much about RealBasic I looked into it. I found the IDE nice but was surprised by it's resultant ...
by swan
Sun Aug 07, 2022 2:35 am
Forum: Applications - Feedback and Discussion
Topic: [Module] EditorEx (Custom Editor Gadget)
Replies: 60
Views: 31179

Re: [Module] EditorEx (Custom Editor Gadget)

Thank you Thorsten1867 for your continued support on ALL your Modules :D
by swan
Sun Jul 24, 2022 8:40 am
Forum: Applications - Feedback and Discussion
Topic: [Module] EditorEx (Custom Editor Gadget)
Replies: 60
Views: 31179

Re: [Module] EditorEx (Custom Editor Gadget)

Just downloaded the latest version and noticed text selection highlighting is not working, in other words copying text with a mouse.
Thank you ...
by swan
Sun Jun 05, 2022 11:27 pm
Forum: Applications - Feedback and Discussion
Topic: [Module] EditorEx (Custom Editor Gadget)
Replies: 60
Views: 31179

Re: [Module] EditorEx (Custom Editor Gadget)

OK I get it now, thank you ...
by swan
Sun Jun 05, 2022 2:47 am
Forum: Applications - Feedback and Discussion
Topic: [Module] EditorEx (Custom Editor Gadget)
Replies: 60
Views: 31179

Re: [Module] EditorEx (Custom Editor Gadget)

Hi,
Have just come across EditorEX, very nice, in particular built in spell check. :) A question though with spellcheck on the example, if I paste an incorrect word via the popup menu it highlights the the word as you'd expect, prob trigered by menu event. However not the same if I type direct - no ...
by swan
Thu Sep 30, 2021 1:10 am
Forum: General Discussion
Topic: PureBasic vs B4J
Replies: 12
Views: 4300

Re: PureBasic vs B4J

Hi, this may or may not answer some of your question. I've used B4A and it's quite good for it's purpose mainly because java is native to android. But to use java on windoze desktop produces a massive overhead, although it still works I guess.
PB's basic is quite different to B4X, it took me a ...
by swan
Thu Sep 02, 2021 1:00 am
Forum: Applications - Feedback and Discussion
Topic: IceDesign GUI designer
Replies: 726
Views: 292058

Re: IceDesign (New) modern GUI designer

Looking good.
A small suggestion, the app doesn't display it's version number anywhere, perhaps on the title bar following the app name or an "About".
Will be useful for you and us as updates flow.
by swan
Tue Jul 23, 2019 11:52 pm
Forum: General Discussion
Topic: Get all contact data for all records in one query
Replies: 7
Views: 3374

Re: Get all contact data for all records in one query

If your getting duplicate records with Inner Join (as long as their the right records) start with Select Distinct * (& so on). It will return only one of each record.
by swan
Tue Jun 11, 2019 8:49 am
Forum: General Discussion
Topic: Need help with project (paid work)
Replies: 0
Views: 1652

Need help with project (paid work)

Hi guys,
I have a project I've been working on for quite a while now and at a point where I need assistance.
On this project I require a stand alone app that's like a mini file manager. This file manager will sit on Windows server 2016 and operate only via remote desktop.
It's file navigation scope ...
by swan
Mon Dec 24, 2018 7:24 am
Forum: Announcement
Topic: PurePDF Version 2.0
Replies: 473
Views: 281045

Re: PurePDF Version 2.0

I have an App for a client that produces a quote including a PDF of it (using PurePDF) and can be 2 to 3 pages. Been working fine for a couple of years.
Have been asked now to include a "terms & conditions" section that will always be the last page of the PDF. The problem is they have a number of ...
by swan
Sat Aug 25, 2018 9:25 am
Forum: General Discussion
Topic: To Fred and Timo: Can we have a discussion about the future?
Replies: 81
Views: 25815

Re: To Fred and Timo: Can we have a discussion about the fut

Agreed.
Easy to get emotional on something like this. Here's hoping Fred can pull a rabbit and please everyone .... :wink: