Search found 4771 matches
- Tue Oct 10, 2023 10:27 am
- Forum: Xbase++ Support
- Topic: Validating bank account numbers
- Replies: 0
- Views: 6845
Validating bank account numbers
Does anyone have some Xbase++ code that validates a bank account number (based on check digit)? I believe that bank account check digits are calculated using the Luhn algorithm. Is this correct? I am not sure. Online documentation says that bank account numbers are always 9 digits or greater, yet my...
- Tue Oct 10, 2023 10:22 am
- Forum: Xbase++ 2.0
- Topic: Opening A Website
- Replies: 16
- Views: 7138
Re: Opening A Website
I didn't know about this.If you use the DCHTMLVIEWER, you just need to add the asset to the DCLIPX_20-project and change any call of "XbpHtmlViewer" to call "XbpHtmlViewer2" there.
I will make this change in eXpress++
- Sun Oct 01, 2023 8:00 pm
- Forum: Xbase++ 2.0
- Topic: How to ALTER a Column using ADS SQL
- Replies: 2
- Views: 3002
Re: How to ALTER a Column using ADS SQL
It took a while to figure out that the column names must be quoted. I had to look in my SqlQuery.prg code to see how I did it 2 years ago.
I forgot.
This is correct syntax:
ALTER TABLE mn_drv
ALTER COLUMN "user" "usr" char(10)
I forgot.
This is correct syntax:
ALTER TABLE mn_drv
ALTER COLUMN "user" "usr" char(10)
- Sun Oct 01, 2023 7:47 pm
- Forum: Xbase++ 2.0
- Topic: How to ALTER a Column using ADS SQL
- Replies: 2
- Views: 3002
How to ALTER a Column using ADS SQL
The Advantage documentation for ALTER TABLE ALTER COLUMN is terrible.
I want to use SQL to change a field name but cannot figure out a syntax that works.
We have a lot of fields in a lot of tables that need to be changed from USER to USR.
Any ideas?
I want to use SQL to change a field name but cannot figure out a syntax that works.
We have a lot of fields in a lot of tables that need to be changed from USER to USR.
Any ideas?
- Mon Sep 18, 2023 4:18 pm
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2727
Re: Error DC_POPDATE when using keyboard
Sorry, I didn't go back far enough in the thread to see that you already had a solution.This is about the same modification as I did. See the first post. I added all the parameters.
- Mon Sep 18, 2023 6:45 am
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2727
Re: Error DC_POPDATE when using keyboard
Here is a fix: _DCCALEN.PRG, starting at line 565: ELSEIF mp1 = xbeK_ESC _DCCalen2(aPopDate,DCCALEN_ABORT,,,,nScale) lOk := .f. ELSEIF mp1 = xbeK_ENTER _DCCalen2(aPopDate,DCCALEN_EXIT,,,,nScale) ELSEIF _DCHotKey( DC_LangMsg(DCMSG_OK), mp1) _DCCalen2(aPopDate,DCCALEN_EXIT,,,,nScale) ELSEIF _DCHotKey(...
- Fri Sep 15, 2023 7:51 am
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2727
Re: Error DC_POPDATE when using keyboard
I could only make it error when pressing the ESC key.
Tell me how you are using it and what keys are giving errors.
Tell me how you are using it and what keys are giving errors.
- Thu Sep 14, 2023 9:35 am
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5414
Re: BBS seems to be back up..
I still think that was some kind of Windows 10 problem, because the attachments did exist and the SQL data looked ok.If now the problem with no access to the attachments will be solved, that would be really nice
I haven't heard that this is still a problem.
- Wed Sep 13, 2023 9:29 am
- Forum: phpBB Board Support
- Topic: Forum is back online
- Replies: 0
- Views: 7139
Forum is back online
I apologize for the forum outage for 2 weeks. I had no idea that so many of you were missing visiting my server in Boise, Idaho, USA. The server missed all of you too. It couldn't understand why it was in the wilderness for so long. When battling the problem, I had to relearn something that I unders...
- Wed Sep 13, 2023 9:13 am
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5414
Re: BBS seems to be back up..
We all missed you too, Tom.I missed the board.