You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > Search Forums

Showing results 1 to 24 of 24
Search took 0.01 seconds.
Search: Posts Made By: FFP
Forum: LIVE PLC Questions And Answers March 8th, 2021, 01:46 PM
Replies: 60
Views: 4,052
Posted By FFP
Dear colleagues, Below is the complete code: ...

Dear colleagues,
Below is the complete code:





Now my main problem is to always run this code with the supervisory running on FT View SE. I need to put this code in a place where it is...
Forum: LIVE PLC Questions And Answers March 5th, 2021, 01:26 PM
Replies: 60
Views: 4,052
Posted By FFP
Thanks Guys.....the complete code worked only I...

Thanks Guys.....the complete code worked only I changed in where DT_FIM_RECEBIMENTO=' ' for DT_FIM_RECEBIMENTO IS NULL....
The complete code below:




Now I work the code with other Ifs to...
Forum: LIVE PLC Questions And Answers March 5th, 2021, 01:06 PM
Replies: 60
Views: 4,052
Posted By FFP
I copied exactly equal....Error showed below ...

I copied exactly equal....Error showed below

Run-time error '438':
Object doesn't support this property or method


Answer for:
Forum: LIVE PLC Questions And Answers March 5th, 2021, 12:25 PM
Replies: 60
Views: 4,052
Posted By FFP
I guess not because in insert code the system...

I guess not because in insert code the system insert line in the same way of update....Date (in code vba) is accepted in database
Forum: LIVE PLC Questions And Answers March 5th, 2021, 08:52 AM
Replies: 60
Views: 4,052
Posted By FFP
I guess Date and Time is not a problem because in...

I guess Date and Time is not a problem because in Insert code it works ok....Strange is that in show message the SQL line code its ok

All the code is:



The table is:
Forum: LIVE PLC Questions And Answers March 5th, 2021, 07:01 AM
Replies: 60
Views: 4,052
Posted By FFP
Thanks a lot....Code function ok but don't save...

Thanks a lot....Code function ok but don't save in database....I guess that TOTAL_LITROS_RECEBIDO is a integer field but in update code the value it's in quotes (')


The code stay:
Forum: LIVE PLC Questions And Answers March 4th, 2021, 01:31 PM
Replies: 60
Views: 4,052
Posted By FFP
I can't get this update to work. The capital...

I can't get this update to work. The capital letters are the columns in the database TOTAL_LITROS - Integer / DT_FIM_RECEBIMENTO - Date / HR_FIM_RECEBIMENTO - Time .... These columns must be updated...
Forum: LIVE PLC Questions And Answers February 26th, 2021, 03:39 PM
Replies: 60
Views: 4,052
Posted By FFP
Hi, Insert in table is function fine, but I...

Hi,
Insert in table is function fine, but I can't update the table. My code is below






When Tag_Updt_RCP_1 = 1 Show Run-time Error -2147217900 (80040e14) - Automation Error
Forum: LIVE PLC Questions And Answers February 26th, 2021, 12:53 PM
Replies: 60
Views: 4,052
Posted By FFP
Thanks Parky ... that was it ..... spaces were...

Thanks Parky ... that was it ..... spaces were missing in the code
Forum: LIVE PLC Questions And Answers February 26th, 2021, 08:43 AM
Replies: 60
Views: 4,052
Posted By FFP
Hello everyone again Now I'm dificullty to...

Hello everyone again
Now I'm dificullty to insertb in Database. When I put a tag in values the tag go to comment and a error shows. If I show dataString via MsgBox the tag value is showed in a popup...
Forum: LIVE PLC Questions And Answers February 25th, 2021, 12:48 PM
Replies: 60
Views: 4,052
Posted By FFP
When I remove Group.Active = true the code has...

When I remove Group.Active = true the code has functional
Thanks a lot all
Forum: LIVE PLC Questions And Answers February 25th, 2021, 11:33 AM
Replies: 60
Views: 4,052
Posted By FFP
New Error

New Error
Forum: LIVE PLC Questions And Answers February 25th, 2021, 11:28 AM
Replies: 60
Views: 4,052
Posted By FFP
Error again

Error again
Forum: LIVE PLC Questions And Answers February 25th, 2021, 05:56 AM
Replies: 60
Views: 4,052
Posted By FFP
New Error

New Error
Forum: LIVE PLC Questions And Answers February 24th, 2021, 04:39 PM
Replies: 60
Views: 4,052
Posted By FFP
New Errors

New Errors
Forum: LIVE PLC Questions And Answers February 24th, 2021, 03:13 PM
Replies: 60
Views: 4,052
Posted By FFP
The general problem is that VB is not able to...

The general problem is that VB is not able to "see" the PLC tags
Forum: LIVE PLC Questions And Answers February 24th, 2021, 02:45 PM
Replies: 60
Views: 4,052
Posted By FFP
This way is even easier, but I won't be able to...

This way is even easier, but I won't be able to update the lines I need to do
Forum: LIVE PLC Questions And Answers February 24th, 2021, 02:37 PM
Replies: 60
Views: 4,052
Posted By FFP
No.... MsgBox("FFP") show a message box...

No....
MsgBox("FFP") show a message box normally with FFP but MsgBox(FFP) shows a empty box but without error

I guess that BD_SETPOINTs tags must be referenced in vba "joined" with PLC tags....
Forum: LIVE PLC Questions And Answers February 24th, 2021, 01:14 PM
Replies: 60
Views: 4,052
Posted By FFP
BD_SETPOINT is a Datatype in PLC....I need use in...

BD_SETPOINT is a Datatype in PLC....I need use in vba code the values of tags in this datatype i.e. BD_SETPOINT.PLACA and BD_SETPOINT.COD_COLETA
Forum: LIVE PLC Questions And Answers February 24th, 2021, 12:28 PM
Replies: 60
Views: 4,052
Posted By FFP
Its the beginning of code.....Before I codifyng I...

Its the beginning of code.....Before I codifyng I need manipulate PLC tags in vba code.
BD_SETPOINT.PLACA is my PLC Tag
Forum: LIVE PLC Questions And Answers February 24th, 2021, 09:23 AM
Replies: 60
Views: 4,052
Posted By FFP
My problem is reference PLC tag in vba code. I...

My problem is reference PLC tag in vba code.
I have LevelTank1 that I need insert in a SQL Server Table called "TBL_RCP", but I can not use this PLC tag in vba code. I try only show but the error is...
Forum: LIVE PLC Questions And Answers February 24th, 2021, 08:23 AM
Replies: 60
Views: 4,052
Posted By FFP
Thanks a lot parky, I solved the connection but...

Thanks a lot parky,
I solved the connection but my problem now is reference the variables of PLC in code. I don't know how catch the value of a PLC tags and include this values in my code. i.e. ...
Forum: LIVE PLC Questions And Answers February 23rd, 2021, 02:30 PM
Replies: 60
Views: 4,052
Posted By FFP
Hi parky, Error in compile Run-time error...

Hi parky,
Error in compile
Run-time error '-2147217843 (80040e4d)
[Microsoft][ODBC SQL Server Drive][SQL Server]Logon failed for user '\'sa\''

Thank you
Fabricio
Forum: LIVE PLC Questions And Answers February 22nd, 2021, 01:18 PM
Replies: 60
Views: 4,052
Posted By FFP
Insert/Update data into tables in SQL Server Express via FTView SE

Hi All,
I need a step-by-step method to insert and update lines in the database SQL Server via software builded in FT View SE.

Thanks.
Fabricio
Showing results 1 to 24 of 24

 
Forum Jump

All times are GMT -4. The time now is 01:42 PM.


.