Hey guys,
apparently there are still some issues about the hbmk2 linking...
We are running a query like that in our application:
- Code: Select all Expand view
SELECT mat.fields, mix.fields FROM material AS mat LEFT JOIN matmix AS mix ON mat.cmat=mix.cmat AND '01' = mix.calmox WHERE mat.data_inc >= '2020-06-14' AND mix.calmox = '01' AND mix.situacao <> 'I' ORDER BY mat.data_inc DESC LIMIT 1000
And we are displaying the variable cResyncSQL like that (right after running the query above):
- Code: Select all Expand view
? oQryBrw:cResyncSQL
Using the hbmk2 to compile and link our appication, we are having this as a return:
- Code: Select all Expand view
SELECT mat.fields, mix.fields FROM material AS mat LEFT JOIN matmix AS mix ON mat.cmat=mix.cmat AND '01' = mix.calmox WHERE <<?>> AND (mat.data_inc >= '2020-06-14' AND mix.calmox = '01' AND mix.situacao <> 'I' ORDER BY mat.data_inc DESC LIMIT 1000)
As you can see, the query structure is wrong.
We started to track this issue, checking on our code and everything, made some changes and nothing happened.
Then we decided to change the linking process to the way we used to do (via ilink) like that:
- Code: Select all Expand view
set oldpath=C:\TEC2000\SGV90
set path=c:\BCC73\bin;C:\TEC2000\SGV90
c:\harbour19\bin\hbmk2 FAZEXE.hbp
set path=%oldpath%
del sgv.exe
c:\bcc73\bin\ilink32 -Gn -aa -Tpe -s @b32.bc
set path=%oldpath%
vfatec.exe
and everything started to work well again...
this is the return we got after this change:
- Code: Select all Expand view
SELECT mat.fields, mix.fields FROM material AS mat LEFT JOIN matmix AS mix ON mat.cmat=mix.cmat AND '01' = mix.calmox WHERE <<?>> AND (mat.data_inc >= '2020-06-14' AND mix.calmox = '01' AND mix.situacao <> 'I') ORDER BY mat.data_inc DESC LIMIT 1000
ps: we didn't change anything on the .HBP file that we shared above.
Does anybody knows what could be wrong this time?