/
deleteQuery.html
executable file
·151 lines (132 loc) · 4.41 KB
/
deleteQuery.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
<!doctype html>
<html>
<head>
<title> </title>
<script src="../fmxj.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="../css/fmxj.css">
<script src="../libraries/prism.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="../libraries/prism.css">
</head>
<body>
<div style="float:right">
<a href="http://SeedCode.com" style="cursor:pointer"><img src="../logowhite.png" alt="SeedCode Logo" style="width:290px;height:93px;display:block"></a>
</div>
<p>
<br>
</p>
<div class="title">
fmxj.js
</div>
<div class="sub-title">
a JavaScript approach to FileMaker Custom Web Publishing
</div>
<div class="sidebar" id="sb"></div>
<div class="content">
<h3 class="functionTitle">deleteRecordURL(fileName, layoutName, recid)</h3>
<div class="text">Create a FileMaker -delete query url by specifying the FileMaker record id. These queries are then passed to the <span class="func">postQueryFMS()</span> function which returns the results as a single object array. The object contains the error code with "0" meaning a succesful delete.</div>
</br>
<div class="divSeparator"></div>
<div class="argument">
fileName
</div>
<span class="text">
Type:
</span>
<span class = "type string">
String
</span>
<div class="desc">
A String of the name of the hosted FileMaker file.
</div>
<div class="divSeparator"></div>
<div class="argument">
layoutName
</div>
<span class="text">
Type:
</span>
<span class = "type string">
String
</span>
<div class="desc">
A String of the name of the target layout in the specified file.
</div>
<div class="divSeparator"></div>
<div class="argument">
recid
</div>
<span class="text">
Type:
</span>
<span class="type number">
number
</span>
<div class="desc">The FileMaker Record ID (-recid) of the record to be deleted.</div>
<div class="divSeparator"></div>
<div class="argument">example 1</div>
<div class="text">Create a -delete query by passing the -recid id to the function. Then POST the query. For this example we'll create a new record to delete (so we don't run out of sample data!)
</div>
<pre class="line-numbers">
<code class="language-javascript">
//create new record query from object
var newRecord = {
"DateStart" : "02/25/2014" ,
"DateEnd" : "02/25/2014" ,
"Description" : "delete example" ,
"Status" : "Open" ,
"Summary" : "test delete example"
} ;
var query = fmxj.editRecordURL("Events", "Events", newRecord);
fmxj.postQueryFMS(query, writeResult);//POST query
function writeResult (js) { // define handler for results.
var record = js[0];
updateElement("example1",JSON.stringify(js, null, 4));//write new record to element as JSON
if(record["-recid"]){//this is the result for our new record.
var recid = record["-recid"];//retrieve record id so we can delete it
var dq = fmxj.deleteRecordURL("Events", "Events", recid );//create query
fmxj.postQueryFMS(dq, writeResult);//POST query
}
else//this is the result of our delete request so write it to element
{
updateElement("example1", JSON.stringify(js, null, 4), true);
}
};</code></pre>
<button id="btn1">try example 1</button>
<pre id="example1" class="result" style="height:600px;max-height:none"></pre>
</div>
</body>
<footer>
<script src="../fmxjDemo.js" type="text/javascript"></script>
<script>
//button for new record
var btn = document.getElementById("btn1");
btn.addEventListener("click",function(){
start = new Date().getTime();
var newRecord = {
"DateStart" : "02/25/2014" ,
"DateEnd" : "02/25/2014" ,
"Description" : "delete example" ,
"Status" : "Open" ,
"Summary" : "test delete example"
} ;
var query = fmxj.editRecordURL("Events", "Events", newRecord);
fmxj.postQueryFMS(query, writeResult, null, relay);//POST query
function writeResult (js,utc) { // define handler for results.
var record = js[0];
if(record["-recid"]){//this is the result for our new record.
var message = createDisplay(js, utc, start);
updateElement("example1",message + "\n\n");
var recid = record["-recid"];//retrieve record id so we can delete it
var dq = fmxj.deleteRecordURL("Events", "Events", recid );//create query
fmxj.postQueryFMS(dq, writeResult, null, relay);//POST query
}
else//this is the result of our delete request so write it to element
{
var message = createDisplay(js, utc, start);
updateElement("example1",message, true);
}
}
});
</script>
</footer>
</html>