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.
Search found 226 matches
- Thu Aug 14, 2025 12:39 am
- Forum: General Discussion
- Topic: How to Check Database Connection is still valid?
- Replies: 9
- Views: 712
- 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))
- 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 ....
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 ....
- 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 ....
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 ....
- 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 ...
- 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 

- 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 ...
Thank you ...
- 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 ...
- 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 ...
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 ...
- 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 ...
PB's basic is quite different to B4X, it took me a ...
- 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.
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.
- 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.
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ....
Easy to get emotional on something like this. Here's hoping Fred can pull a rabbit and please everyone ....
