Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info.
SEARCH THE FOXITE.COM VISUAL FOXPRO FORUM ARCHIVES
Please enter one or more search terms:
search (case insensitive):


order by:


sort:
SEARCH RESULT Results 4826 - 4850 of 9518 for Functions. (0.312002 seconds)


RE: It is still challange for every VFP Expert
, but they no longer have the reference available for VFP6. If you have the MSDN Reference Library for you VFP6 version, check for the existance of these functions, or any of the other functions. > > If you're wanting pixels over foxels, and if the MCOL() and MROW() functions are supported in VFP6, then change the second parameters of MCOL() and MROW() to 3 to calculate pixels. > Let me know your result. > Regards, Ryan Hinton > Dear

RE: It worked Yuri. But why?
Thread ID: 61655 Simon Arnold RE: It worked Yuri. But why? Most likely, the error is in the line: > nRecCount = _TALLY > >You should use here: > >nRecCount = recc() > Thanks Yuri. But I don't understand why. This would then be the second mistake I met in Tamar Granor's book on MSOffice automation. > Rank Merida Talisay City, Cebu, Phil. RECCOUNT() will return the number of Records in a Table. _TALLY Contains the number of records processed by the most recently executed table command. The following table lists the commands and functions that return status information and store the number of records processed in _TALLY only when executed against local tables and views. APPEND FROM Command

RE: ITaskbarList3 Interface in VFP
sets of related functions. These function sets are called interfaces, and the functions of an interface are called methods. Further, COM requires that the only way to gain access to the methods of an interface is through a pointer... that make up that interface. These methods determine how a client can use the object's data." http://msdn.microsoft.com/en-us/library/ms688484%28VS.85%29.aspx "A COM interface is not an object. It is simply a related group of functions

RE: Java script to vfp for google maps
a txt file and can import its data to a memo,a table dbf... i added two functions to the google map script to do : -write to the txt file in each call programmed -event listener in javascript to trapp the click event on the map

RE: Java script to vfp for google maps
a txt file and can import its data to a memo,a table dbf... > i added two functions to the google map script to do : > -write to the txt file in each call programmed > -event listener in javascript to trapp the click event on the map... reply and for your time. The functions that you added are excellent as they will help me a lot for getting any information from google maps to VFP, You area life saver. Anyway out of curiosity, Caude Fox mentioned a JSON class for VFP

RE: Java script to vfp for google maps
Thread ID: 234787 Yousfi Benameur RE: Java script to vfp for google maps > Javascript is a script and can write easily to a text file. i use this trick to export what i want from the javascript hosted in a web page to export sequentially to a text file the output i choice . Then vfp knows how to manipulate a txt file and can import its data to a memo,a table dbf... > i added two functions to the google map script to do : > -write to the txt file in each call programmed... back. Yousfi Benameur > > > Yousfi thank you very much for your reply and for your time. The functions that you added are excellent as they will help me a lot for getting any information from google maps to VFP, You area life

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 Mustapha Bihmouten RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) Hello Argie What about saving the value in an xml file et load/read it from vfp Hope it helps Mustapha Bihmouten

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 dencio cabacis RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) Hello! Try adding a hidden field in your html, then in your javascript save that value to the hidden field when triggerd and then access it in vfp like this; *** assumes you have a webbrowser control on your form, and your html hidden field *** is named "vfp". MESSAGEBOX(thisform.web.document.getElementById

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 Argie Badua RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) > Hello Argie > What about saving the value in an xml file et load/read it from vfp > Hope it helps > Mustapha Bihmouten ========== I can't modify the html application anymore, meaning its already AS IS and I don't have authorization to modify it. I just want to incorporate my application to the existing

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 Argie Badua RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) > > Hello! > Try adding a hidden field in your html, then in your javascript save that value to the hidden field when triggerd and then access it in vfp like this; > *** assumes you have a webbrowser control on your form, and your html hidden field *** is named "vfp". > MESSAGEBOX(thisform.web.document.getElementById

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 William Sanders RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) > > Hello! > Try adding a hidden field in your html, then in your javascript save that value to the hidden field when triggerd and then access it in vfp like this; > *** assumes you have a webbrowser control on your form, and your html hidden field *** is named "vfp". > MESSAGEBOX

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 dencio cabacis RE: Javascript Functions & Variables to VFP Again, the Html application cannot be modified because i have no access with it. The scenario would be like this, the HTML Application is fixed. I have a VFP application and need the value of a variable from that HTML Application. SO how can I retrieve that value of a variable so I can trigger one of the events on my VFP Application. Argie, Sorry, I thought you have access to the html code. I already posted before you reply to Mr. Mustapha. As Mr. Sanders said, ask a local javascript expert at your elbow for a few hours, show him how you are doing screen scraping for a web browser in VFP, and go forth. Regards.

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 William Sanders RE: Javascript Functions & Variables to VFP We have an html application that is made through a .net architecture but i've checked the code its javascript. There is a function there and will return a value to the variable when triggered. How can I get that value and incorporate that to my VFP application? Any help would be very much appreciated. Thank you! > Hope it helps...:) > Hello Argie > What about saving the value in an xml file et load/read it from vfp > Hope it helps > Mustapha Bihmouten > ========== I can't modify the html application anymore, meaning its already AS IS and I don't have authorization to modify it. I just want to incorporate my application

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 Argie Badua RE: Javascript Functions & Variables to VFP I got already the code from the HTML application. And i've already seen the variable tthat i want to get the value of it. So what i need now is how can i get that value of the variable to my VFP. I understand the DOM but i really don't know how to do it. If you can give me a sample code then i really appreciate it. Thanks! Hope it helps...:)

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 William Sanders RE: Javascript Functions & Variables to VFP I got already the code from the HTML application. And i've already seen the variable tthat i want to get the value of it. So what i need now is how can i get that value of the variable to my VFP. I understand the DOM but i really don't know how to do it. If you can give me a sample code then i really appreciate it. > Thanks! > Hope it helps...:) How are you encapsulating the browser IN VFP ? Regards [Bill] --------------------- William Sanders / Electronic Filing Group VFP based webhosting at http://efgroup.net/vfpwebhosting DotNetConversions [back to da FOX] at http://efgroup.net/dotnetconversion

RE: Javascript Functions & Variables to VFP
Thread ID: 130224 William Sanders RE: Javascript Functions & Variables to VFP I got already the code from the HTML application. And i've already seen the variable tthat i want to get the value of it. So what i need now is how can i get that value of the variable to my VFP. I understand the DOM but i really don't know how to do it. If you can give me a sample code then i really appreciate it. > Thanks! > Hope it helps...:) Hmmmmmm. You tried a forum search, yes? keyword o 'browser' ? This isn't a DOM example - but you can at least get started. http://www.foxite.com/archives/automate-web-actions-from-within-vfp-0000021883.htm Regards [Bill] --------------------- William Sanders / Electronic

RE: Jim, Simon new problem
Thread ID: 66400 Jim Winter RE: Jim, Simon new problem > By the way is locate command more fast and more reliable than seek? > I don't know about reliability as I've never had any problems with SEEK (as long as I remember to use ALLTRIM) but as far as speed is concerned in my experience SEEK is generally faster than LOCATE but this will not be obvious until you are searching on a large table. The advantage of LOCATE is that you can search on several conditions whereas SEEK you are constrained to one which is indexed. > HTH > > John Weller John, Its generally recommended to not use any trim functions on an index because FoxPro uses the length of the first record to determine the length of the index

RE: Jim, Simon new problem
Thread ID: 66400 John Weller RE: Jim, Simon new problem > By the way is locate command more fast and more reliable than seek? > I don't know about reliability as I've never had any problems with SEEK (as long as I remember to use ALLTRIM) but as far as speed is concerned in my experience SEEK is generally faster than LOCATE but this will not be obvious until you are searching on a large table. The advantage of LOCATE is that you can search on several conditions whereas SEEK you are constrained to one which is indexed. > HTH > > John Weller > John, > Its generally recommended to not use any trim functions on an index because FoxPro uses the length of the first record to determine the length of the index

RE: JKey and VFP 9.0
Thread ID: 220436 Jim Denney RE: JKey and VFP 9.0 Never mind, the problem is with the default index we use to search. Searches by name, tax numbers, zip codes, city, etc. still work. The index uses some Foxpro functions, I just have to figure out which one JKey doesn't like and invent an alternate solution. We are migrating a VFP 7.0 app to VFP 9.0. The application uses JKey to handle incremental searching and is the one feature the users are concerned with. When we call JKey with the 9.0 version, it displays the search window and a browse window, but typing in characters does not move the record pointer. > Does anyone know what could be causing this? I have used 9.0 before with JKey and it worked, but it was a couple

RE: joining files with update sql
Thread ID: 154465 Andy Kramek RE: joining files with update sql Hi Dan Sorry to jump in here but I have a question about how to get data types to agree in a join statement in SPT. > That is, I want to say left join tablea on t1.field=t2.field - but t1.field is char and t2.field is int. Is there way to turn one into the other in the SPT select statement? Something like CAST()? You can use CAST() or you can use any of the string functions to convert integers to strings or vice versa: *** Join on Integer WHERE INT(VAL( t1.field )) = t2.field WHERE CAST( t1.field AS INT ) = t2.field *** Join on Char String WHERE ALLTRIM(STR( t2.field )) == ALLTRIM(t1.field) WHERE ALLTRIM( PADL( t2.field

RE: Joining selects in one table
Thread ID: 205392 Rodolfo Esquivel RE: Joining selects in one table Thank you for your help, but SQL is saying an error Msg 1033, Level 15, State 1, Procedure sp_archivo, Line 42 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. I only copied your sintax Rodolfo, ORDER BY is issued for ALL records from the recordset, no matter how many UNIONs you have there. So if you want to order only one of these SELECTs just use so called derived table: .... union all SELECT * FROM (select t1.itemcode, '' as descripcion, convert(varchar(20),convert(int,t1.quantity)) from

RE: Joining selects in one table
Thread ID: 205392 Borislav Borissov RE: Joining selects in one table union all SELECT * FROM (select TOP 100 PERCENT t1.itemcode, '' as descripcion, convert(varchar(20),convert(int,t1.quantity)) from opor as t0 inner join por1 as t1 on t0.docentry=t1.docentry where t0.docnum=@numdoc ORDER BY t1.itemcode) Tbl1 Thank you for your help, but SQL is saying an error > Msg 1033, Level 15, State 1, Procedure sp_archivo, Line 42 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. > I only copied your sintax > > Rodolfo, ORDER

RE: Joining selects in one table
Thread ID: 205392 Rodolfo Esquivel RE: Joining selects in one table Thanks a lot, first option didn´t work, second option works PERFECTLY, third option I don´t know how to use functions. Many thanks, you solved my problem Of course it is invalid. I don't think you should try ordering with all those unions and trust that it would work later as you want anyway for this error you could simply code it as: > select * from (select top 100 percent t1.itemcode, '' as descripcion, convert(varchar(20),convert (int,t1.quantity)) from opor as t0 inner join por1 as t1 on t0.docentry=t1.docentry where t0.docnum=@numdoc order by t1.itemcode) tbl > But I wonder why don't you

RE: Jpg Format to Ico Format
: http://books.google.com.br/books?id=iF97jVKcqhEC&pg=PA577&lpg=PA577&dq=foxpro+loadpicture&source=bl&ots=6tr3-ItGqX&sig=HgJyGcL_s74mTUe-EBwwBPeemeI&hl=pt-BR&sa=X&oi=book_result&resnum=6&ct=result#PPA577,M1 "These two functions are intended for use with ActiveX controls, such as the ImageList, that require graphic resources to display. Rather than accepting filenames, these controls need object handles. These functions supply that handle and can save the resulting

RE: JS to Vfp
can run forms, functions, procedures. All this thanks to Antonio Muñoz de Burgos and his "HTML MENU & VFP" sample... His link for download is at: http://www.portalfox.com/index.php?name=News&file=article&sid=2020 I hope this example


Result Page: 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 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381