Search found 4773 matches

by rdonnay
Thu Oct 12, 2023 5:52 am
Forum: Xbase++ 2.0
Topic: Validating bank account numbers
Replies: 4
Views: 3142

Re: Validating bank account numbers

You are seeking checker for US bank acc number or standard iBAN transaction account ?
Actually, all of our bank transactions are with US banks so I really don't need an IBAN validation, however, I may need to go that route if I can't find an easy way to validate a US bank account.
by rdonnay
Tue Oct 10, 2023 10:41 am
Forum: Xbase++ 2.0
Topic: Validating bank account numbers
Replies: 4
Views: 3142

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: 6993

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: 7217

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: 3022

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: 3022

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: 2731

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: 2731

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: 2731

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: 5459

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.