Good morning, I am trying to figure out if it is possible to check if these invoice lines exist or not.
Here are the table and column name: INVOICELINE.INVOICELINENUM (a required field if created)
Here is a picture of what I am talking about. (Do not worry about security. the picture is from a demo test site so all information is fake)
is there any way to check if these fields exist or not? (they do not exist unless the user clicks on "New Row")
Example: line 11 does not exist right now. How would I go about to see if it did or not?
This is what I have so far:
SELECT DISTINCT iv.invoicenum, iv.description FROM invoice AS iv JOIN invoiceline AS ivl ON iv.invoicenum = ivl.invoicenum AND iv.siteid = ivl.siteid /* = 'nothing' and yet somehow not null? */ WHERE iv.invoicenum NOT IN (SELECT invoicelinenum FROM invoiceline WHERE invoicelinenum IS NOT NULL) I get 0 results where I should get more than 0.
Trying this from autoit v184.108.40.206 and SCITE 220.127.116.111.0 :
help file , page "Language Reference - Variables" , sample autoit script about maps:
Maps must be declared before use by defining their scope using the 'Global/Local/Static' keywords. Local $mControls
So is my test script : only with this local declation.
-check syntax is OK
- running script :
test.au3" (13) : ==> Variable subscript badly formatted.: Local $mControls Local $mControls[^ ERROR ->14:51:49 AutoIt3.exe ended.rc:1
any clue ?
Hello, i want to search several directories for files with the largest numbers behind them (Like "video123") . They dont have a datatype. But there are also files with longer names and datatypes in these folders (Like "video778.mp4"). Is it possible to filter the _FileListToArray Syntax from
to smth. like
Here is my Code
#include <ButtonConstants.au3> #include <GUIConstantsEx.au3> #include <WindowsConstants.au3> #include <array.au3> #include <File.au3> $filedir = @ScriptDir & "\" _checkfile() Func _checkfile() ConsoleWrite("______________________" & @CRLF) Local $arr = ["music", "picture", "video"] For $i = 0 To UBound($arr) - 1 Local $arrayfiles = _FileListToArray($filedir & $arr[$i], $arr[$i] & "*", 1) If @error = 1 Then ConsoleWrite($arr[$i] & "Error 1") EndIf If @error = 4 Then ConsoleWrite($arr[$i] & "Error 2") ;Exit EndIf $arrayfilter = _ArrayMax($arrayfiles, 0, 1) Global $stringfiles = StringReplace($arrayfilter, $arr[$i], "") ConsoleWrite($arrayfilter & @CRLF) Next EndFunc ;==>_checkfile
Script running good but error in line 7.
When i run this script :
#include <IE.au3> #include <Array.au3> $oIE = _IEAttach ("Shop") $oTable = _IETableGetCollection ($oIE, 1) $aTableData = _IETableWriteToArray ($oTable) For $inumber = 1 To UBound($aTableData) -1 $table = $aTableData[$inumber] MsgBox(0, "", $table) Next I got Error: array variable has incorrect number of subscripts or subscript dimension range exceeded
Good morning guys, i hope that you're all well.
guys, i have a problem and i hope that you can help me
i've created an 3d array
the array Contain a Categories info
$array[n] = Categorie name
$array[n] = Categorie file path
$array[n] = Categorie contents number
$array[n][m] = link name
$array[n][m] = link url
$array[n][m] = link section name
in my tool i want to add an option to delete a Category
as you know the Categorie mean that must delete a region from the array
when i tried to use _arrayDelete
with the 2d array it work well
but here i couldn't find any way to do that, can any one help me please?
thanks in advance.