Connie McBride

I have this statement in my code, but it doesn't always post to the dataset. no sql statement is generated - but only sometimes. 1) the reg_value is always changed in this procedure. 2) the procedure is called in hundreds of places. 3) the procedure works in most cases, not in others. 4) I recently updated from delphi 12.1 to delphi 12.2, and it used to work all the time. I am trying to figure out what changed that would cause it to NOT post the record. the code: aStream.Position := 0; tBlobField(dmCommon.tblGridIniREG_VALUE).LoadFromStream(aStream); freeAndNil(aStream); dmCommon.tblGridIni.Post;---> no SQL statement is generated. nothing is seen through the tracers (sql profiler or firedac trace) this same code works in Delphi 12.1, no issue. the structure: all fields are filled in with values. the issue happens when trying to update. adding new records is fine. doing an Can't include sample data, because it seems unprintable characters are part of it I am saving the grid settings from a devexpress grid by writing to a memory stream and loading it to the varchar(max) field. The problem isn't inherently devexpress, the same version of devexpress works in delphi 12.1. tracing deep into the code, it is returning that there is no change to the reg_value field, so it isn't creating the update statement. Any ideas which flag needs to be unset (or set)? cached updates is not in use.

that's probably it, but weird that it didn't yack at that point. (so, a typo) thanks

weird issue. I added a watch to my watch list: and instead of a string value, I am getting the component properties or something: my settings: my visualizers: this is pretty useless to me currently. how do I fix it?

because the library was built to run in delphi11, where cw_usedefault was defined as a dword. that constant changed in delphi12, where it is now an integer

I changed the variable in the code to be an integer vs a dword, and now it works. but heads up to anyone who runs into this.

I am building the crystal 13 vcl components for delphi 12. I don't have rtl in my search path Ucrpe.pas is failing on this line : function TCrpe.SendOutput : Boolean; var nLeft, nTop, nWidth, nHeight : DWord; xHandle : hWnd; begin .... if FWindowSize.FLeft = -1 then nLeft := CW_USEDEFAULT <<<<<<HERE nLeft is defined as DWord. so the .pas isn't in my search path, it's the same code that has worked in delphi 10 up to delphi 11.3.

I'm actually not. one of my .pas files is using CW_USEDEFAULT, which is leading to the compile error.

Using Delphi 12, upgrading from Delphi11, using windows 32 as target. when building, I am getting this error: [dcc32 Errorr E1012 Constant expression violates subrange bounds the errror is in Winapi.Windows const {$EXTERNALSYM CW_USEDEFAULT} CW_USEDEFAULT = Integer($80000000); any ideas how to fix this?

I managed to get the odbc to work for the dbexpress connection by setting the connection string in the ini file to: #ConnectionString=Driver={ODBC Driver 17 for SQL Server};server=pv06;database=qcLocal;uid=ccm;pwd=ccm ConnectionString=dsn=qclocal;database=qcLocal; of course, now the firedac connection doesn't work.... (still working on that)

I don't seem to have a connection issue with firedac. I am having the connection issue with dbexpress (I am in process of converting to firedac, so currently have both connections) when I use the data explorer (using dbexpress), this is how I set it up: I have also tried: when I click 'test connection', I get:

I setup the connection string: Driver={ODBC Driver 17 for SQL Server};Server=pv06;DAtabase = qclocal;schema=dbo;Trusted_Connection=yes; double clicked on it, and opened an sql window. setup a query (view exists in the dbo schema), and got this:

not sure how to answer that, but when I double click on the odbcConnection, it tells me note: I don't want to set up an actual connection, just want to get the ini method to work

Using Delphi 10 Seattle with dbExpress and Delphi 11 Alexandria with both dbExpress and firedac connecting to : sqlserver 2008 - 2022 I am using an ini to initialize the connections, and now I need to change it from using the native client libraries to the ODBC library. I keep getting 'unknown driver message, with the unknown driver set to whatever I set drivername to (I have tried odbc and ODBC Driver 17 for SQL Server) at one point, I didn't get a connection error anymore, but doing the first query returned an error running the first query on a view, saying the view wasn't found. Can someone please help fix? [QC2022] DriverUnit=Data.DBXOdbc DriverPackageLoader=TDBXOdbcDriverLoader,DBXOdbcDriver230.bpl DriverAssemblyLoader=Borland.Data.TDBXOdbcDriverLoader,Borland.Data.DbxOdbcDriver,Version=23.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b MetaDataPackageLoader=TDBXOdbcMetaDataCommandFactory,DbxOdbcDriver230.bpl MetaDataAssemblyLoader=Borland.Data.TDBXOdbcMetaDataCommandFactory,Borland.Data.DbxOdbcDriver,Version=23.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b GetDriverFunc=getSQLDriverMSSQL LibraryName=dbxmss.dll VendorLib=msodbcsql17.dll DriverName = ODBC Driver 17 for SQL Server MaxBlobSize=50000000 OSAuthentication=False PrepareSQL=True ErrorResourceFile= SchemaOverride=%.dbo Schema=dbo HostName=pv06 Database=qcLocal blobsize=-1 localecode=0000 isolationlevel=ReadCommitted os authentication=False prepare sql=False connecttimeout=60 mars_connection=False ConnectionString=Driver={ODBC Driver 17 for SQL Server};Server=pv06;DAtabase = qclocal;schema=dbo;Trusted_Connection=yes;