Search found 4762 matches

by rdonnay
Tue Oct 10, 2023 10:41 am
Forum: Xbase++ 2.0
Topic: Validating bank account numbers
Replies: 4
Views: 1568

Validating bank account numbers

Does anyone have Xbase++ code for validating a bank account number using the check digit algorithm?

I'm not sure if the Luhn algorithm is correct for validating bank accounts.
It claims that account numbers are 9 digits or greater yet many of the accounts in our database are only 8 digits.
by rdonnay
Tue Oct 10, 2023 10:27 am
Forum: Xbase++ Support
Topic: Validating bank account numbers
Replies: 0
Views: 2279

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...
by rdonnay
Tue Oct 10, 2023 10:22 am
Forum: Xbase++ 2.0
Topic: Opening A Website
Replies: 16
Views: 4083

Re: Opening A Website

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 didn't know about this.
I will make this change in eXpress++
by rdonnay
Sun Oct 01, 2023 8:00 pm
Forum: Xbase++ 2.0
Topic: How to ALTER a Column using ADS SQL
Replies: 2
Views: 1393

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)
by rdonnay
Sun Oct 01, 2023 7:47 pm
Forum: Xbase++ 2.0
Topic: How to ALTER a Column using ADS SQL
Replies: 2
Views: 1393

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?
by rdonnay
Mon Sep 18, 2023 4:18 pm
Forum: eXpress++ Support
Topic: Error DC_POPDATE when using keyboard
Replies: 6
Views: 2136

Re: Error DC_POPDATE when using keyboard

This is about the same modification as I did. See the first post. I added all the parameters.
Sorry, I didn't go back far enough in the thread to see that you already had a solution.
by rdonnay
Mon Sep 18, 2023 6:45 am
Forum: eXpress++ Support
Topic: Error DC_POPDATE when using keyboard
Replies: 6
Views: 2136

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(...
by rdonnay
Fri Sep 15, 2023 7:51 am
Forum: eXpress++ Support
Topic: Error DC_POPDATE when using keyboard
Replies: 6
Views: 2136

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.
by rdonnay
Thu Sep 14, 2023 9:35 am
Forum: Announcements
Topic: BBS seems to be back up..
Replies: 8
Views: 3565

Re: BBS seems to be back up..

If now the problem with no access to the attachments will be solved, that would be really nice ;)
I still think that was some kind of Windows 10 problem, because the attachments did exist and the SQL data looked ok.

I haven't heard that this is still a problem.
by rdonnay
Wed Sep 13, 2023 9:29 am
Forum: phpBB Board Support
Topic: Forum is back online
Replies: 0
Views: 2517

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...