Search:

No errors unless I attempt to use the alias table name which of course won't work. Using the column name alone just gets me nothing probably because the DD knows about the alias, not the master...

Pardon the perhaps silly question, but there is no way to make SQL Filters work with alias tables, is there? Considering there's no real table in the database with the alias's name? I've dug through...

No argument Samuel, I work with Postgres all the time and with that do have to handle the dates correctly

Yeah Wil, you're family!

Not necessarily. MSSQL will handle a US date, not sure about European, so it will depend on the database being used.

Mat,
Use it exactly as you show it in the constrain as. psSQLFilters are essentially the "where" clause in an SQL statement so a prospective query might end with



where Book.Date_req >=...

Done!

Good choice, MSSQL Express. Unless you have an absolutely humongous database it should work nicely. I think you should be able to use the most recent version of MSSQL with DF-17

his wife might have something to say about that...

;)

Hi Wil,
Sorry about posting that vague question, I'm in the middle between my systems guy and the forum and at this point not terribly knowledgeable about AWS. We are successfully running Postgres...

Terrific work!

Is anyone using RDS Postgres on AWS with a create database statement and Mertech driver? We've had some trouble getting this to work...

So not being "data" it shouldn't be of concern... Thanks Chuck

Thanks Vincent.

well you could have done a +99,...

My understanding of this installation is that the users will RDP into an AWS client of some sort which will show the application and then of course connect to the database. A status panel running in...

Thanks Samuel ;)

I thought that I’d already posted this question but I can’t find it anywhere.

My customer is moving their application and Postgres database to AWS. Every report uses a .bp and the statuspanel...

I guess no one else thinks this is important

We're in the middle of moving to PostgreSQL 12 which has proved interesting. No insurmountable problems yet...

Thanks Vincent, as always, there are arguments for both conditions and it may depend on the users & environment for what's ultimately done.

We use Postgres too but in any case I wouldn't bother storing images in the database, I'd rather store them on disk and just store the path to the image. There may be very good reasons for storing...

This isn't a DD issue, it's a cj issue. This used to work with the old dbGrids. I looked and onEditChanging help says it won't work with comboforms. I'm sure someone has found a workaround, I'm...

Hi Mike,
Have you set it in both the cjgrid column and the DD? I remember having a problem with this but haven't had any comboforms in cjgrids lately

Just tried it and even setting both doesn't...