Question Re: SQL server posting in Additional Q&A

SQL server posting

Former Member — Fri, 15 Aug 2008 22:37:24 GMT

Hi,

I'm currently a new hire and just started training. Currently I'm creating new finance application and I'm trying to input data into the database with an any-by-any wizard input schedule.

I get a reply back that it has successfully sent the data, however when I browse through the SQL database I notice that for every entry entered, somehow automatically a negative entry is also entered. Hence I do not find any data in our database through BPC (because it is zero).

Thanks,

Brian

Re: SQL server posting

Former Member — Mon, 18 Aug 2008 06:56:43 GMT

Brian,

This must be something with default logic.

Go to administration, select the application, select script logic, select default logic. Now comment all lines out by putting a double slash (
) in front of all lines and save and validate this logic file. Than try it again.

Alwin

Re: SQL server posting

Former Member — Thu, 21 Aug 2008 23:29:08 GMT

Thanks for your reply Alwin.

I actually figured out that it was right and that it was something I did not understand correctly.

Re: SQL server posting

Former Member — Fri, 22 Aug 2008 02:50:27 GMT

Hi Brian

Try to refresh your input schedule report and see if you still can get the value back. (re-query)

If yes, then the value should be inside your database now.

Then what else you have to do is let us know which table that you queried to get the value in the database.

Halomoan