Search found 4777 matches

by rdonnay
Sun Oct 15, 2023 9:35 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 17865

Re: ADS

This should take significantly less time than a year.
I trust your instincts.
I'll have a talk with Bobby.
by rdonnay
Sun Oct 15, 2023 6:11 am
Forum: Xbase++ 2.0
Topic: Error in XbpToolbar
Replies: 11
Views: 14317

Re: Error in XbpToolbar

Anyone who is using eXpress++ had had DCTOOLBAR and DCSTATUSBAR for about 20 years now and this is all Xbase++ code.
by rdonnay
Sun Oct 15, 2023 6:10 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 17865

Re: ADS

Tom -

I would really enjoy working on a migration project from ADS to PGDBE.
Bobby and I talked about doing this with his Taxi Medallion software, but the payback can take years to recover if the migration takes more than 1 year.
by rdonnay
Thu Oct 12, 2023 10:53 am
Forum: Xbase++ 2.0
Topic: Validating bank account numbers
Replies: 4
Views: 7427

Re: Validating bank account numbers

The Luhn algoritme should work with any length.
I will give it a try. Thanks.
by rdonnay
Thu Oct 12, 2023 5:52 am
Forum: Xbase++ 2.0
Topic: Validating bank account numbers
Replies: 4
Views: 7427

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

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

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

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

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

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?