Search:

Anders

The first thing I would do is to put a breakpoint in Procedure List in the cRESTAPIObject, with a condition that htTable = {the file number of the table you are having a problem with}.

...

Samuel - yup, constraints are what is messing it up.

However... I thought that Send Clear would also Clear the parents: "The Clear message clears the Main_File of the DDO and then propagates up...

Samuel - good idea! You can be my Friday afternoon brain! :)

Mike

Hi - DF 20.1 on MSSQL (Win 10)

I am doing something which I'd assumed would just work, but strangely just isn't. Probably because it is late on a hot Friday afternoon and my brain has already...

Anders

I'm sorry, but I have no idea what is going on with that. I'm as baffled as you are. :(

Mike

Or just don't set it at all. :p

Mike

Anders

Do things work in Database Explorer on those tables?

Mike

Anders - I'm not sure. You may be better asking Data Access. Raise an HDE ticket - they are pretty quick answering those.

Mike

Anders

You may need to check that the correct Modules are present in IIS manager: DataFlex nn.n HTTP Module 32bit and DataFlex nn.n HTTP Module 64bit (where nn.n is your DF version).

Mike

Anders

If you are not returning an error due to something done in OnPreRequest then I don't think it is the WebApp causing the problem.

I the example I posted on the DataFlex Wiki (using my...

Anders

Perhaps I am not understanding properly...

Do you want to secure your API or not? If not, then just return the requested data (or perform whatever action is requested) without checking...

Thanks Wil! :)

Mike

Edgar

See ProcessDataSet and OnProcessDataSet.

Mike

Roel

AFAIK, FD files are only used at compile time to tell tha compiler what to replace filenames and fieldnames with. I'm sure someone will correct me if that's b0ll0cks! ;)

Mikw

Actually, now I consider it, using headers is probably better. :)

Mike

Clive

I always use the query string for filters, which in my experience usually apply to GETs anyway, which as you note, can't (by spec I think) have a body. URL encoding them might be a good...

FlexQL maybe?

Mike

Changed my approach - used OnEntry (which does have the correct SelectedColumn value) to dynamicaly Set pbEditable.

Mike

Emil

OK, now digging into an issue I've been having, that turns out not to work (at least not the way I want it to). :(

I'm augmenting OnEntering, in order to work out whether I should allow...

Thanks Martin.

I already have it working using Ian's mechanism, but I'll give that a try as well (seems more elegaint to me if I can get it to work ;))

Mike

Edgar

You want to send the output to the Local Default printer? The one the user's browser is connected to? I suggest that you print to PDF, open that PDF file (probably in a new tab/window, but...

Thanks Ian! :)

Mike

Does anybody know of a way to detect if an embedded SQL SELECT statement returns a NULL in its column values?

Mike

Thanks Emil - that's what I was missing! :)

Mike

Help me out here - I'm obviously being stupid. :(

How can I detect the current row in a cCJGrid / cCJGridColumn?

Mike