Search found 1432 matches

by Vaughn
Sat May 05, 2018 8:35 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

After actually going in to change the proc, the @result is not used for a new record id, it looks like maybe what is used to display error codes on the web site, so I did not remove them. I will go back to trying to get my separate little project running to experiment with using multiple statements ...
by Vaughn
Fri May 04, 2018 9:21 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

I am thinking about just removing the output parameter from the DB call. I can add a select in the API to leave the functionality alone at that level so we don't have to modify any of the programs that use that API. Then all the DB calls will stay nice and simple. You OK with that? If so, I can send...
by Vaughn
Sun Apr 29, 2018 4:58 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

If you want to commit the import code, I will test it.
by Vaughn
Wed Apr 25, 2018 11:25 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

I added the alias here and ran an export/import from the database tools and I don't get that error. Can you test it from workbench or something and see if you get the same error?
by Vaughn
Sun Apr 22, 2018 3:14 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

The error does not look related to the 'Import' values. You can just try to execute the object_add by itself and verify. I am still at work and will look at it in a couple hours when I get home. I think the @Results is meant to return the new Object_ID, which would need to be assigned to something, ...
by Vaughn
Sun Apr 08, 2018 9:46 am
Forum: Hardware
Topic: Raspberry Pi projects
Replies: 0
Views: 2207

Raspberry Pi projects

I am trying to get away from Phidgets due to price and popularity, I would rather focus on Pi support. Some people were supporting the Pi through Rest, which is fine, but I would like to support a couple things, like UDP, MySQL and maybe an api. MySQL is so easy in Python, I thought it would be nice...
by Vaughn
Wed Apr 04, 2018 5:58 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

Kirk, Try this SQL, and I am committing the api changes now. CREATE PROCEDURE osae_sp_schedule_export(IN pname VARCHAR(255)) BEGIN DECLARE vResults TEXT; SELECT CONCAT('CALL osae_sp_schedule_recurring_add (\'', schedule_name,'\',\'', COALESCE(`object_name`, ''),'\',\'', COALESCE(`method_name`, ''),'...
by Vaughn
Wed Apr 04, 2018 4:36 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

I am going to do the exports this morning. Will update post later.

Did you test the pattern exports? I just was using it as the basis of the schedule export and the parameter name doesn't seem to match what is used in the match select. I will try to look at it more after I finish schedules.
by Vaughn
Wed Mar 28, 2018 10:31 am
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

I broke Jabber, I am guessing because of the .NET upgrade, so no hurry. Work has been super rough here too. This upgrade has taken so long, I don't think it matters how fast we get it out, but if it goes good, I would focus on faster updates in the future. So don't burn out or get in trouble, more i...
by Vaughn
Fri Mar 16, 2018 11:15 pm
Forum: Developers
Topic: 049 tracking thread
Replies: 131
Views: 34771

Re: 049 tracking thread

I should have figured it out quicker myself, I am rusty.


Vaughn